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                ...
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.

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

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