Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I am looking for some help on a calculation I am doing. I just need help calculating the previous day excluding weekends and holidays. I have a date table setup with the holidays and weekends already mapped and I was using a calculation to get the previous day excluding weekends, but I do not know how to also configure it to skip holidays. Any help would be appreciated. Here is the calc I am currently using from another post.
_PreviousDay =
VAR _Date =
dimDate[Date]
VAR _latestDate = _Date - 1
VAR _DD =
SWITCH (
WEEKDAY ( _Date ),
2, _Date - 3,
1, _Date - 2,
7, _Date - 1,
_latestDate
)
RETURN
_DD
Solved! Go to Solution.
You posted this in the Power Query board. Do you want the result in Power Query or in DAX?
_PreviousDay =
VAR _Date =
[Date]
RETURN MAXX(FILTER(dimDate,[Date]<_Date && [Holiday Or Weekend]=FALSE()),[Date])
You posted this in the Power Query board. Do you want the result in Power Query or in DAX?
_PreviousDay =
VAR _Date =
[Date]
RETURN MAXX(FILTER(dimDate,[Date]<_Date && [Holiday Or Weekend]=FALSE()),[Date])