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.

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]))