Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Return single date

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!
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , A measure or measure var

     

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

  • HarishKM's avatar
    HarishKM
    Super User
    5 years ago

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

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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.