The easiest way to find the max value across multiple columns in Power BI is to use the Maximum function in the Add column tab of the Power Query Editor. The following example shows how to use this function in practice. Example: How to Find Max of Multiple Columns in Power BI Suppose we have […]
Learning to Find the Maximum Value Across Multiple Columns in Power BI Read More »
Often you may want to remove the “Total” row from a table in Power BI. Fortunately this is easy to do and the following example shows how to do so in practice. Example: How to Remove “Total” Row in Power BI Suppose we have the following table in Power BI named my_data that contains information
Learning Power BI: How to Remove the Total Row from Tables Read More »
If you have a table with blank values in Power BI and you create a slicer in a report, then a (Blank) option will appear in the slicer, such as the following slicer: Often you may want to remove this option from the slicer since it usually doesn’t make since to slice data based on
Learning Power BI: Filtering Slicers to Remove Blank Options Read More »
You can use the following syntax in DAX to remove specific characters from a string: Team_New = SUBSTITUTE(‘my_data'[Team], “Team_”, “”) This particular example creates a new column named Team_New that removes the string “Team_” from each string in the Team column of the table named my_data. The following example shows how to use this syntax in
Learning to Remove Characters from Strings in Power BI Using DAX Read More »
You can use the following syntax in DAX to calculate the standard deviation of values in a column: Std Dev of Points = STDEV.P(‘my_data'[Points]) This particular example creates a new measure named Std Dev of Points that calculates the standard deviation of values in the Points column of the table named my_data. Note that there
Learning to Calculate Standard Deviation in Power BI with DAX: A Step-by-Step Guide Read More »
You can use the following syntax in DAX to calculate the average value in a column: Avg Points = AVERAGE(‘my_data'[Points]) This particular example creates a new measure named Avg Points that calculates the average value in the Points column of the table named my_data. The following example shows how to calculate the average value of
Learning to Calculate Averages Using DAX in Power BI Read More »
Introduction to Monthly Aggregation in Power BI The ability to calculate accurate and meaningful averages grouped by specific time periods is fundamental to effective business intelligence and data analysis. In Power BI, analyzing sales or performance metrics monthly provides crucial insights into seasonal trends, long-term growth, and performance volatility that daily data might obscure. Calculating
Learning to Calculate Monthly Averages in Power BI with DAX Read More »
You can use the following syntax in DAX to calculate the average value in a column while ignoring any values equal to zero: Avg Points = CALCULATE ( AVERAGE ( ‘my_data'[Points] ), FILTER ( ‘my_data’, ‘my_data'[Points] <> 0 ) ) This particular example creates a new measure named Avg Points that calculates the average value
Learning to Calculate Averages in Power BI While Excluding Zero Values Read More »
While Excel provides the straightforward `AVERAGEIF` function for calculating conditional averages, Power BI requires a more sophisticated approach using Data Analysis Expressions (DAX). This method leverages key functions to implement conditional logic based on row context. The following syntax demonstrates how to write the equivalent of an AVERAGE IF function in DAX, designed specifically for
Learn How to Calculate Conditional Averages in Power BI Using DAX Read More »