Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Need Help

Hi Experts, I have a data and i need to find out what is the max period in the below data. please help me on this. Period Quarter 1 Q1 2 ...

Need Help

v-juanli-msft
7 years ago
Hi Anonymous

Create measures

max period = CALCULATE(MAX(Table1[Period]),ALLEXCEPT(Table1,Table1[Quarter])) month plan = MAX([Year plan])/12 Quarter plan = [max period]*[month plan]

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous

Not applicable

7 years ago

Hi,

I want to calculate the QTD plan numbers for each quarter.

If I get the maximum period of the Quarter then i can calculate the plan numbers again each order.

Ex:

Yearly plan is 1000

monthly plan is 1000/12 = 83.33

so if I want to calculate the QTD value for Q1 = 3*83.33 = 250

Hope u can understand the scenario.

Regards

Swamy

v-juanli-msft

Community Support

7 years ago

Hi Anonymous

Create measures

max period = CALCULATE(MAX(Table1[Period]),ALLEXCEPT(Table1,Table1[Quarter]))

month plan = MAX([Year plan])/12

Quarter plan = [max period]*[month plan]

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.