Forum Discussion

apnorona's avatar
apnorona
New Member
6 years ago
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

 

Need Help
Tips and Tricks
  • zaza's avatar
    zaza
    6 years ago

    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 
    ) )

     

     

     

  • apnorona's avatar
    apnorona
    6 years ago

    Hi  

     

    Yes, the variation should be between Thursday and Monday. For example, these cases could occur on Holliday days on any working day.

     

    Regards,

    AN