Forum Discussion
Hierarchal level Calculation - Different DAX for Each Level
Hello, I am new Power BI and not really versed with DAX formula. I am facing a small problem. I have phrased my question in google in many ways but maybe I couldn't express what I want. so let ...
Thank you, Amit. unfortunately, it didn't work for me. let me explain what I want from this measure.
My measure has two steps:
1. On Product Level I want to return zero if the qty of product in previous month is zero and if its qty is not zero then I want to calculate the difference in Unit Cost ( current month - previous month ) and multiply it by the current month qty.
2. secondly on Category Level I want to just sum up the cost difference that is calculated for each product in the same category in the previous step.
and Ultimatly I want to calculate Cost Variance per Product and per-category at each level.