I am working on this graph. I have the following format (this is made up data)
I want to calculate b*a^(-b) *t^(b-1)
where I created another table for t that includes one column t and values 1-60 with an increment of 1.
How can this be done in DAX? I also want to graph the output of this equation against time (t= 1-60), then I want to add a slicer for project number so the graph can react to that specific project
I did some reaserch and looks like I might need a python or an R code, but can we do it in edit query in DAX?
Go to Solution.
- You will need a Project Parameters table:
- And a time table:
- So, you can create a calculated table EquationData:
EquationData = CROSSJOIN('Project Parameters', 'Time')
- Then, you have to create a column to calculate your equation:
- Finally, you can plot your chart:
I apreciate a kudo and mark as the solution. Thanks
View solution in original post
Sorry for the DAX column formula in the last post, I had a copy and paste error. The correct is:
Result = EquationData[b]*EquationData[a]^(-EquationData[b]) *EquationData[Time]^(EquationData[b]-1)
You can download the solution in this link:
I apreciate you dive a kudo (like), it is important to me to be better ranking in the community. Thanks
This is great.
Can you please add the DAX equation for that formula?
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!