Remove the display of months June 22 until December 22

[dolevh]

Hi, 

I have data until the end of 2022 but I want to present the data until today (May 2022) 

this is my dax : 

Cumulative ProjectTable = 
VAR ABV = CALCULATE ( LASTDATE( ProjectTable[date] ))

RETURN 
IF( SELECTEDVALUE('Date'[Date]) > TODAY(), BLANK(), 
    CALCULATE(COUNT(ProjectTable[id]), 'ProjectTable'[active] = 1,
        FILTER( ALLSELECTED('Date'), 
            'Date'[Date] <= MAX('Date'[Date] ))))  

But on visualization, it looks like this:

 

Which Dax do I need to take off the months of June 22 until December 22?

thanks all!

[dolevh]

Thanks to all its working 🙂

[v-rongtiep-msft · Accepted solution]

Hi @dolevh ,

Please refer to my pbix file to see if it helps you.

Create a measure.

_today=IF(MAX('Table'[date])>TODAY(),0,1)

Then put the measure into the filter.

Then the dates June 22 until December 22 were removed.

If I have misunderstood your meaning, please provide your pbix file without privacy information and your desired output.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[johnt75]

Add a new column to your date table to return true if the date is on or before TODAY(), then use that as a filter on the chart.