Forum Discussion
Solved
PREVIOUSDAY for workdays
Hi,
I´m trying to calculate a variation of a measure only for workdays (Monday to Friday). Still, the PREVIOUSDAY formula takes all the days (Monday to Sunday), and I have the problem in the variation of Monday because I don´t have data on Sunday. I need to calculate the variation of the first workday of the week with the last workday that has data in the previous week:
I´ve tried to filter the dates without values (Saturdays and Sundays), but the PREVIUOSDAY formula calculates including the weekend:
Could anyone help me?
Regards,
Andres Norona
Try this:
PreviousWorkday = IF ( WEEKDAY ( MAX ( Table[Date] ), 2 ) = 7 ), MAX ( Table[Date] ) - 3, IF ( WEEKDAY ( MAX ( Table[Date] ), 2 ) = 6 ), MAX ( Table[Date] ) - 2, MAX ( Table[Date] ) - 1 ) )
4 Replies
- zaza
Resolver III
Try this:
PreviousWorkday = IF ( WEEKDAY ( MAX ( Table[Date] ), 2 ) = 7 ), MAX ( Table[Date] ) - 3, IF ( WEEKDAY ( MAX ( Table[Date] ), 2 ) = 6 ), MAX ( Table[Date] ) - 2, MAX ( Table[Date] ) - 1 ) )Thank you, I´m going to try it.
AN
