Limit Date Dimension

[m1nkeh]

Hi,

I have a measure as follows:

SimpleCalc :=CALCULATE (
    SUM ( [Premium] ),
    FILTER ( ALL ( Dates ), Dates[Date] <= MAX ( Dates[Date] ) )
)

But what this ends up doing is taking the final value an running it right to the end of the date dimension... whereas technically this is right, it's a pain in the backside because my date dim is many years in the future..

how can i limit the date dimension to only show up to something more reasonable... i'm not massively fussed if it's the current day, or perhaps month, or even perhaps year...

just not running off into the future infinitely would be nice

cheers!

 

[m1nkeh]

got there in the end... this seemed to do the trick:

Test := IF ( MIN ( 'Dates'[Date] ) <= TODAY(), 1 )

does what i need anyway..

i also changed 'all dates' in the first post to:

DATESBETWEEN(Dates[Date], BLANK(), TODAY())

just in case that mattered... other suggestions are welcome.