Forum Discussion

Kathir's avatar
Kathir
Frequent Visitor
3 years ago
Solved

Dax Help

hi ,   How to get the max number by category as shown below? Thanks    ID Week Total Videos Max Videos 1 1 3 3 2 1 3 3 1 2 4 4 2 2 4 4 1 3 2 2 2 3 2 2 ...
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    Hi Kathir ,

     

    Please create a new column:

    Column = CALCULATE(MAX('Table'[Total Videos]),FILTER('Table','Table'[Week] = EARLIER('Table'[Week])))

     

    Best regards,

    Yadong Fang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Tanushree_Kapse's avatar
Tanushree_Kapse
Impactful Individual
3 years ago

Hi Kathir ,

 

 

You can create the below column with the DAX:

Max Videos = CALCULATE(MAX('Table'[Total Videos]),GROUPBY('Table','Table'[Total Videos]),'Table'[ID])
 
 
Mark this as a solution, if I answered your question. Kudos are always apreciated.
Thanks