Return single date

[Anonymous]

Hello,

Sorry I'm new to Power BI. But within a measure I'm looking for return just single date. But this date needs to be the newest day minus 3. For example:

last date on the dataset 20/03/2021 and I want it to return 17/03/2021.

This is what I've tried so far but it returns multiple dates:

PARALLELPERIOD('Calendar'[Date],-3,DAY)

Thanks in advance!

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can use the ALL function to remove all filters and return a single date.

Measure = CALCULATE(MAX('Calendar'[Date])-3,ALL('Calendar'))

Best Regards,

Stephen Tao

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

[HarishKM]

@Anonymous Hey Bruh ,
You can take inspriration from my calculation .

latest date = CALCULATE(MAX(data[Order Date]),DATEADD(data[Order Date],-3,DAY))

[amitchandak]

@Anonymous , A measure or measure var

maxx(ALLSELECTED('Calendar'),'Calendar'[Date]) -3