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

[Fair-UL]

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

[mauriciosotero · Accepted solution]

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 · Accepted solution]

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]

This is great.

Can you please add the DAX equation for that formula?

[mauriciosotero · Accepted solution]

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