Forum Discussion
powerlight1
4 months agoHelper I
find max value based on another filtered column
Hi I am trying to create a column that retreive the MAX "WeekStart" column based DayCount = 7 in the table below. I found a post in 2020 with a solution that requires a 20 lines of DAX code, is th...
- 4 months ago
pls try
ThxAlot
4 months agoSuper User
= CALCULATE( MAX( Data[weekStart] ), Data[DayCount] = 7 )