I have a measure for the average cost of product in the current year.
I have a measure for the average cost of product in 2018 (current year offset = -4). I am trying to solve the equation below:
Avg Cost 2018 * (x^4) = Avg Cost 2022. Is there a dax formula that solves for x?
Solved! Go to Solution.
How about this?
= Power(Divide([Avg Cost 2022], [Avg Cost 2018]), 0.25)
Pat
How about this?
= Power(Divide([Avg Cost 2022], [Avg Cost 2018]), 0.25)
Pat
Thanks so much, Pat!
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
108 | |
75 | |
66 | |
50 | |
48 |
User | Count |
---|---|
164 | |
87 | |
77 | |
70 | |
67 |