Using relative dates

[jedr89]

Hi!

I'm trying to make the relative date filter to show 'This Day' VS 'Last Day', however, the relative date filter us showing current date for both cases, even when I try to show 'Last Day' it shows today's date. (see attached image)

Any suggestions on this?

Thanks in advance!

[amitchandak]

@jedr89 , no in relative date you can have a date

you can last day using measure

Day behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Day))

Day behind Sales = CALCULATE(SUM(Sales[Sales Amount]),previousday('Date'[Date]))

or try like

Power BI How to use/compare two Date/Period slicers: https://youtu.be/WSeZr_-MiTg