Forum Discussion
Creating Cumulative What If Line
Hi JiaJie ,
Here are the steps you can follow：
1. In Power query, Add Column – Index Column – From 1.
2. In Modeling – New parameter.
Minimum = 5
Maximum = 45
Increment = 5
3. Create calculated column.
Index = RANKX('Parameter','Parameter'[Parameter],,ASC)4. Create the relationship between the two tables with [Index]
5. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
JiaJie , a measure like
Countx(filter(allselected(Table), Table[shift_info] <=max(Table[shift_info] ) ),Table[shift_info] ) *5
or
Countx(filter(allselected(Table), Table[shift_info] <=max(Table[shift_info] ) ),Table[shift_info] ) * [what if measure]
Hi amitchandak,
I have tried using your CountX method however it is counting the number of shift info multiplying the what if.
However I am looking to just create a Y=MX line M is the what if number. I have tried to create a distinct table of shift info and rank it follow by muktiplying the what if. But it is still giving me a flat line.