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
gmasta1129
Helper III
Helper III

Previous Day - Excluding Weekend

Hello,

 

I have a report that runs 5 days a week (excludes weekends).  There is a "Run Date" column which contains the date the report was run.  I would like to retreive the previous day from the run date but I am having an issue because of weekend dates.  

 

For example, August 29th is a Monday.  Run Date = 8/29/2022.  The Previous Day should be Friday August 26th 2022 8/26/2022 

and not Sunday August 28th  8/28/2022

 

What type of formula can i use for this? 

1 ACCEPTED SOLUTION
ahmadibrahimbus
Resolver III
Resolver III

Dear @gmasta1129 ,

please use the below dax:

Previous_date = if( FORMAT(Sheet1[Run Date], "dddd")="Monday",Sheet1[Run Date]-3,Sheet1[Run Date]-1)
let me know if it's help.

View solution in original post

2 REPLIES 2
gmasta1129
Helper III
Helper III

Worked perfectly. Thank you for your help! 

ahmadibrahimbus
Resolver III
Resolver III

Dear @gmasta1129 ,

please use the below dax:

Previous_date = if( FORMAT(Sheet1[Run Date], "dddd")="Monday",Sheet1[Run Date]-3,Sheet1[Run Date]-1)
let me know if it's help.

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.