Forum Discussion

Anonymous's avatar
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                       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  

 

Need Help
  • v-juanli-msft's avatar
    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.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous ,

     

    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

    • Anonymous's avatar
      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Anonymous ,

         

        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

  • sampathK's avatar
    sampathK
    Microsoft Employee
    7 years ago

    Hello,

       You can try this below, by going through New table 

     

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