Getting the TOP Rows per Category -DAX VS Power Query “M”
Here is the data of Top 30 tennis players in the World from 5 different Continents Our Objective is to[…]
Read moreCategory: DAX
Using VALUE parameter in RANKX
Many of us who have used this function have rarely if ever seen the VALUE argument of RANKX function in[…]
Read moreSumIf in Power Query and Calculated Column
IN EXCEL The SumIF in Excel is pretty easy CALCULATED COLUMNS USING DAX you can use one of the following[…]
Read moreUse MEASURES in Slicers, Rows and Chart Axis
So we have this sample financial data of 2 technology giants..Microsoft and Apple Using this Data we create 3 MEASURES[…]
Read moreGet the Previous Row
Microsoft Excel provides a simple way to refer to previous row. In Power BI, you can’t use this approach …but[…]
Read moreCustom Sorting in Power BI
Power BI desktop allows users to sort various visuals (Table Visual, Matrix, Charts etc) by Row Fields, Value fields, MEASURES,[…]
Read moreAggregating Values in Multiple Columns using DAX
Suppose we have monthly sales for 10 Products as follows. Our objectives are to Compute the Maximum Monthly Sales for[…]
Read moreCount only Working Days between 2 Dates
DATEDIFF function in DAX allows you to count the difference between 2 dates in terms of DAYS….(or even HOURS ,[…]
Read moreIncorrect Total for a MEASURE
When a measure is used in a Table or Matrix Visualization, it is common to get either no total or[…]
Read morePulling Text Data from Many Side Table into One Side
Typically One Side Table is your LookUp Table. That is to say….Normally we lookup or pull a text value from[…]
Read more