Forum Discussion
NewbieJono
Post Partisan
Post PartisanYear To Max Date
is there a method of doing a year to max date in a fact table. i need the year to start 01/04 and I need to calculate volumes to the max date of another dateset. i will also need to do a same...
Like this:
InScope = VAR _MaxFromFactTable = MAX( YOUR_FACT_TABLE[Date] ) RETURN IF( 'Calendar Table'[Date] <= _MaxFromFactTable, 1, 0 )
Good luck! 🙂
NewbieJonoPost Partisan
Post Partisanhow would i do the in scope calculation?
Sergii24
Super User
Super UserLike this:
InScope =
VAR _MaxFromFactTable = MAX( YOUR_FACT_TABLE[Date] )
RETURN
IF(
'Calendar Table'[Date] <= _MaxFromFactTable,
1,
0
)
Good luck! 🙂