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 moreMany of us who have used this function have rarely if ever seen the VALUE argument of RANKX function in[…]
Read moreIN EXCEL The SumIF in Excel is pretty easy CALCULATED COLUMNS USING DAX you can use one of the following[…]
Read moreSo we have this sample financial data of 2 technology giants..Microsoft and Apple Using this Data we create 3 MEASURES[…]
Read moreMicrosoft Excel provides a simple way to refer to previous row. In Power BI, you can’t use this approach …but[…]
Read morePower BI desktop allows users to sort various visuals (Table Visual, Matrix, Charts etc) by Row Fields, Value fields, MEASURES,[…]
Read moreSuppose we have monthly sales for 10 Products as follows. Our objectives are to Compute the Maximum Monthly Sales for[…]
Read moreDATEDIFF function in DAX allows you to count the difference between 2 dates in terms of DAYS….(or even HOURS ,[…]
Read moreWhen a measure is used in a Table or Matrix Visualization, it is common to get either no total or[…]
Read moreA common task for many Excel Users is to compare 2 or more lists and find out the missing values[…]
Read moreThe most Powerful tool (arguably) in Excel …Pivot Tables… do not allow the Distinct Count of a Field …..(at least[…]
Read more