Forum Discussion

gmasta1129's avatar
gmasta1129
Resolver I
3 years ago
Solved

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 r...
Need Help
  • ahmadibrahimbus's avatar
    ahmadibrahimbus
    3 years ago

    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.
ahmadibrahimbus's avatar
ahmadibrahimbus
Resolver III
3 years ago

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.