Forum Discussion
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 |
| 1 | 4 | 5 | 5 |
| 2 | 4 | 4 | 5 |
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.
2 Replies
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.ThanksHi 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.
