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.

v-yadongf-msft's avatar
v-yadongf-msft
Community Support
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.