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 variati...
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

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

    Thank you, I´m going to try it.

     

    AN