Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
) )
Hi danextian,
Yes, the variation should be between Thursday and Monday. For example, these cases could occur on Holliday days on any working day.
Regards,
AN
Hi @apnorona ,
" I need to calculate the variation of the first workday of the week with the last workday that has data in the previous week"
Does this mean that If Friday has not value, then the variation should be between Thursday and Monday?
Proud to be a Super User!
Hi danextian,
Yes, the variation should be between Thursday and Monday. For example, these cases could occur on Holliday days on any working day.
Regards,
AN
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |