Filter out data by dates till yesterday

[Anonymous]

Hello Powerbi Developers,

I am having one requirement.

I am having date column in which data is for whole year, but we want to show dynamically with help of Today() -1 function.

eg today is 11/10/22 i want to show data in dashboard till 10/10/22.

So how can we implement it.

Please help me out here on above issues/blockers.

Regards,

[Aburar_123]

Hi @SgtSnowman ,

Please write the measure like below and place it in the visual level filter of the slicer

uptoTodayFlag = if(MAX(Date_Dim[Date])<=TODAY(),1,0)

[Samarth_18]

Hi @Anonymous ,

You can create a measure as below and use it as filter on the visuals you want to apply this filter.

Measure = 
IF ( MAX ( 'Table'[Date] ) <= TODAY () - 1, 1, 0 )

Thanks,

Samarth

[Anonymous]

Not Working !!

[Samarth_18]

@Anonymous ,could you please show how you have implemented? or if you could share your PBIX after removing sesitive data?

[SgtSnowman]

I have this same question - I have a date table that has dates until the end of the year 2023, but I only want my slicer to show dates up until yesterday. 
I tried this measure but it doesn't accept it?

Measure =

IF ( MAX ( 'Dates'[FullDateAlternateKey]) <= TODAY () - 1, 1, 0)

[Samarth_18 · Accepted solution]

@SgtSnowman , You need to apply measure as visual level filter. Please refer the attached PBIX.

[SgtSnowman]

Ah, that works. Thank you!

One final thing, if I may.... I have two tables that each have their own date (in the same format). Is there a way to make one slicer do a filter on dates and pull back the necessary statistics? 

I can share my pbix file if that makes it easier

[Samarth_18]

@SgtSnowman You could create a date table and join your tables to it. Then use date table on slicer.