Prior day(Calendar date)

[refint650]

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

[refint650]

Let me try syntax, thanks

[v-deddai1-msft · Accepted solution]

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

[HashamNiaz]

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