Forum Discussion

refint650's avatar
refint650
Helper III
5 years ago
Solved

Prior day(Calendar date)

Hello 

 

I have calendar date slicer having values for current month  Sample value Calendar date : 2021-06-18'. when user selects value how can i write expression to get prior 7th day value from calendardate data.?

 

If selected value is 2021-06-18.  2nd calculated column should return 2021-06-11..

 

Thanks

Ref

General Comment
Need Help
Show and Tell
Tips and Tricks
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi refint650 ,

     

    For measure you can use:

     

    Last 7 days = MAX(Calendar[Date])-7

     

    For calculated column:

     

    Last 7 days = Calendar[Date]-7

     

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

     

    Best Regards,

    Dedmon Dai

3 Replies

  • HashamNiaz's avatar
    HashamNiaz
    Solution Sage
    5 years ago

    Hi refint650 !

     

    You can use following DAX to create a measure to return Date value prior 7 days of selected date value;

     

    Last 7 Date = CALCULATE(MIN('Calendar'[Date]), DATEADD('Calendar'[Date], -7, DAY))

     

    Regards,

    Hasham

    • v-deddai1-msft's avatar
      v-deddai1-msft
      Community Support
      5 years ago

      Hi refint650 ,

       

      For measure you can use:

       

      Last 7 days = MAX(Calendar[Date])-7

       

      For calculated column:

       

      Last 7 days = Calendar[Date]-7

       

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

       

      Best Regards,

      Dedmon Dai