Need Help

[Swamy3105]

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                       Q1

3                       Q1

4                       Q2

5                       Q2

So, if

Q1 the maximum period is  = 3

Q2 the maximum period is  = 5

likewise i want to find out the maximum period in the each quarter.

How to get this done?

Regards

Swamy  

[sampathK]

Hello,

   You can try this below, by going through New table 

New Table=SUMMARIZE('Date','Date'[Quarter],"Max",MAX('Date'[Period]))

[AiolosZhao]

Hi @Swamy3105 ,

I'm not sure how you want to use the maxinum, beucase I think you can put the quarter as dimension in table, and create a measure ( =max(period), then you can get the maxinum period by quarter I think.

Please try.

Aiolos Zhao

[Swamy3105]

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

Hi  @Swamy3105 

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.

[AiolosZhao]

Hi @Swamy3105 ,

So I assume that you already have a measure to get the result of monthly plan.

And if you want to create a table, then I think you just need to put the quarter into the table.

then create a measure like : a = max(period)

then create another measure like :  b = a * your_monthly_plan

then put b into your table.

Please try.

Aiolos Zhao