Forum Discussion
alexbjorlig
Helper IV
Helper IVHow to filter table with latest day, dynamically?
Hi everyone. Still trying to understand the basics of CALCULATE and filter context. This problem is really hard for me to solve, so looking forward to your input/solutions. My objective is to bu...
alexbjorlig
You have built the correct logic but you don't need to iterate over the fact table.
I modified your measure:Latest = VAR __category = MAX('fact'[category]) VAR __maxdate = CALCULATE( MAX('fact'[date] ) , ALLSELECTED('fact' ) , 'fact'[category] = __category ) return INT ( max('fact'[date]) = __maxdate )
Fowmy
Super User
Super Useralexbjorlig
You have built the correct logic but you don't need to iterate over the fact table.
I modified your measure:
Latest =
VAR __category = MAX('fact'[category])
VAR __maxdate = CALCULATE( MAX('fact'[date] ) , ALLSELECTED('fact' ) , 'fact'[category] = __category )
return
INT ( max('fact'[date]) = __maxdate )
alexbjorligHelper IV
Helper IVThanks man - amazing when the solution turn out to be more simple than expected š