cancel
Showing results for
Did you mean:
Fair-UL 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
mauriciosotero 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

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

Fair-UL 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.

mauriciosotero 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   