Forum Discussion
Solved
Getting YTD / YTG Values (Dynamic)
Hi, My example data: I'm trying to use the TODAY() function to dynamically calculate YTD / YTG values using various measures: Gets the Current Month Number (so 10 for October) T...
SOLVED:
Hi,
you need to use FILTER() to make this work. Like this:
Total YTD Value =
CALCULATE (
SUM ( 'A - Monthly Values'[Value] ),
FILTER ( 'A - Monthly Values', 'A - Monthly Values'[Month] < [Current Month] )
)