Tag: calculated columns power bi

Format Data In Power BI: Addressing Irregular Data Formats

Format Data In Power BI- Addressing Irregular Data Formats

In today’s blog post, we’ll discuss Problem of the Week #6. I’ll show you how to format data in Power BI involving the use of power query. The screenshot below is the solution that you should have after you’ve done all the data transformation. The actual balance number was at $685,616.33. You may watch the

Continue reading

Power BI Timesheet & Wages DAX Solutions

Power-BI-Timesheet-Wages-DAX-Solutions

This blog centers around a Power BI timesheet and the associated wage costs. I’m going to show you how to calculate time data and wage type using DAX. I’m going to demonstrate a DAX solution using measures and another one using calculated columns. You may watch the full video of this tutorial at the bottom

Continue reading

Calculated Columns Power BI: Tips & Best Practices

Best Practices When Using Calculated Columns In Power BI

This tutorial will discuss the best practices in using calculated columns in Power BI. We’ll also be going through the DAX formulas used to create them. In previous discussions, we’ve gone through how to write different measures in Power BI, but another technique we can use is to create calculated columns. Other than measures, using

Continue reading