Forum Discussion
Difference (Accross Then Down)--DAX Formula
Hi Greg_Deckler
I did the same thing but there is some mismatch, I think you are finding the difference for current value and previous MAX value, but I want Difference between Current value and Previous value----->
Here is the output what I got from your calculation, and what I need exactly
Here is the Pbix file also,
https://drive.google.com/file/d/1DqF4zUb5RYgYIiJPrBAh-7je83A6mYlz/view?usp=sharing
kaushikd- I created a measure for this that does away with all of the intermediary tables, columns, etc. I put it in the Quick Measure gallery here:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Across-then-Down/m-p/366354#M108
Hi Greg_Deckler
I did the same thing but there is some mismatch, I think you are finding the difference for current value and previous MAX value, but I want Difference between Current value and Previous value----->
Here is the output what I got from your calculation, and what I need exactly
Here is the Pbix file also,
https://drive.google.com/file/d/1DqF4zUb5RYgYIiJPrBAh-7je83A6mYlz/view?usp=sharing
kaushikd- I created a measure for this that does away with all of the intermediary tables, columns, etc. I put it in the Quick Measure gallery here:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Across-then-Down/m-p/366354#M108
Great..!!
It worked fine...this made me your fan... :smileyvery-happy:
Thanks a lot
kaushikd- Glad we got there. That's an odd calculation can you tell me the business context in which this is used? Is this something dealing with HR, manufacturing, finance? Just curious, I haven't come across that particular calculation before.