DAX to generate series

[rishic]

I have my base table like below:

Cust_Class	1_Factor	2_Factor
C1	3	0.2
C2	2	0.4

Need to generate a table using DAX:

1. 1st column is a Series that start from 5 and goes till 9 with diffrence of 0.1(Generate series)

2. 2nd column is calculation based on base table and 1st column.

Sample Output:

Power	Consum
5.1	1_Factor * power(5.1,2_Factor)
5.2	1_Factor * power(5.2,2_Factor)
5.3	1_Factor * power(5.3,2_Factor)
5.4	1_Factor * power(5.4,2_Factor)
5.5	1_Factor * power(5.5,2_Factor)
5.6	1_Factor * power(5.6,2_Factor)

Can someone please help to create above output.

[v-jiascu-msft]

Hi @rishic,

What's values of the column "Consum" exactly? For example:

Power           Consum

5.1                3 * power(5.1, 0.2)     // C1

5.1                2 * power(5.1, 0.4)    // C2

Which row is the one you want?

Best Regards,

Dale  

[rishic]

Both the rows, it will be plotted in a line graph from C1 and C2.(Cross join I guess)