cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Fair-UL Frequent Visitor
Frequent Visitor

What is the best way to calculate an equation of two parameters I have in a table for t 1-60

I am working on this graph. I have the following format (this is made up data)

 

project numberab
1000.30.5
1010.50.7
1020.50.4

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?

TIA

2 ACCEPTED SOLUTIONS

Accepted Solutions

Re: What is the best way to calculate an equation of two parameters I have in a table for t 1-60

Hi,

 

- You will need a Project Parameters table:

Capture2.PNG

 

- And a time table:

Capture3.PNG

 

- So, you can create a calculated table EquationData:

EquationData = CROSSJOIN('Project Parameters', 'Time')

- Then, you have to create a column to calculate your equation:

EquationData = CROSSJOIN('Project Parameters', 'Time')

- Finally, you can plot your chart:

Capture4.PNG

 

I apreciate a kudo and mark as the solution. Thanks

 

 

View solution in original post

Re: What is the best way to calculate an equation of two parameters I have in a table for t 1-60

Hi,

 

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:

Pbix file 

 

I apreciate you dive a kudo (like), it is important to me to be better ranking in the community. Thanks

View solution in original post

3 REPLIES 3

Re: What is the best way to calculate an equation of two parameters I have in a table for t 1-60

Hi,

 

- You will need a Project Parameters table:

Capture2.PNG

 

- And a time table:

Capture3.PNG

 

- So, you can create a calculated table EquationData:

EquationData = CROSSJOIN('Project Parameters', 'Time')

- Then, you have to create a column to calculate your equation:

EquationData = CROSSJOIN('Project Parameters', 'Time')

- Finally, you can plot your chart:

Capture4.PNG

 

I apreciate a kudo and mark as the solution. Thanks

 

 

View solution in original post

Fair-UL Frequent Visitor
Frequent Visitor

Re: What is the best way to calculate an equation of two parameters I have in a table for t 1-60

This is great.

Can you please add the DAX equation for that formula?

Re: What is the best way to calculate an equation of two parameters I have in a table for t 1-60

Hi,

 

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:

Pbix file 

 

I apreciate you dive a kudo (like), it is important to me to be better ranking in the community. Thanks

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,469)