Month Filter greater than today blank

[Anonymous]

Hi,

I have this filter that takes out the dates past today, but I cant get it to do at the the month level.

Sold Units, Cumulative =

IF(SELECTEDVALUE(Dates[Date])>TODAY(), blank(),

Calculate( [Sold Units],

filter(ALLSELECTED(Dates),

        Dates[Date] <= MAX(Dates[Date]))))

How do I make this filter make months forward blank? Like the date one.

Thanks!

[danextian]

Hi @Anonymous 

You want this line hidden?

[danextian]

I used a dummy data with a similar data model as yours (probably) and the measure below works fine

YTD2 =
IF (
    MAX ( Dates[Date] ) <= TODAY (),
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER ( ALLSELECTED ( Dates[Date] ), Dates[Date] <= MAX ( 'Dates'[Date] ) )
    )
)

Here's a sample pbix

https://drive.google.com/file/d/1DdI_SAgjNwchVCdIevXvGmhLfVwn6i5V/view?usp=sharing 

[Anonymous]

Hi @danextian

Thanks for the help. I tried that formula and it looks like it is pulling all the units? Not sure. I have a measure in Calculate instead of a sum of a column though.

Thanks!

Trevor

Sold Units, Cumulative =

IF (

    MAX ( Dates[Date] ) <= TODAY (),

    CALCULATE ([Sold Units]

        ,

        FILTER ( ALLSELECTED ( Dates[Date] ), Dates[Date] <= MAX ( 'Dates'[Date] ) )

    )

)

[danextian]

What do you mean by "it is pulling all the units"? Can you please share a sanitzed pbix of your data model?