Dax Help

[Kathir]

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
1	4	5	5
2	4	4	5

[v-yadongf-msft · Accepted solution]

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]

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