Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
refint650
Helper II
Helper II

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

1 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

View solution in original post

3 REPLIES 3
refint650
Helper II
Helper II

Let me try syntax, thanks

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
Solution Sage
Solution Sage

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.