cancel
Showing results for
Did you mean:
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 number a b 100 0.3 0.5 101 0.5 0.7 102 0.5 0.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
Member

## 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:

- 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:

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

- Finally, you can plot your chart:

I apreciate a kudo and mark as the solution. Thanks

Member

## 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)`

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

3 REPLIES 3
Member

## 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:

- 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:

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

- Finally, you can plot your chart:

I apreciate a kudo and mark as the solution. Thanks

Frequent Visitor

This is great.

Member

## 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)`

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

Announcements

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

#### 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

Find out where you can attend!

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