cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Reply
apatnola
Helper I
Helper I

Solve for x in y = x^z when you know Y and z

‎12-01-2022 03:27 PM

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?

 

Labels:
Message 1 of 3
204 Views
0
1 ACCEPTED SOLUTION
ppm1
Solution Sage
Solution Sage

‎12-01-2022 05:25 PM

How about this?

 

= Power(Divide([Avg Cost 2022], [Avg Cost 2018]), 0.25)

 

Pat

Microsoft Employee

View solution in original post

Message 2 of 3
146 Views
2 REPLIES 2
ppm1
Solution Sage
Solution Sage

‎12-01-2022 05:25 PM

How about this?

 

= Power(Divide([Avg Cost 2022], [Avg Cost 2018]), 0.25)

 

Pat

Microsoft Employee
Message 2 of 3
147 Views
apatnola
Helper I
Helper I
In response to ppm1

‎12-02-2022 06:46 AM

Thanks so much, Pat!

Message 3 of 3
113 Views
0

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

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!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

View All
Top Solution Authors
View All