cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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:

Daily Variation.JPG

 

 

 

 

 

 

 

I´ve tried to filter the dates without values (Saturdays and Sundays), but the PREVIUOSDAY formula calculates including the weekend:

Daily Variation filtering weekend.JPG

 

 

 

 

 

Could anyone help me?

 

Regards,

Andres Norona

 

4 REPLIES 4
Highlighted
Resolver II
Resolver II

Re: PREVIOUSDAY for workdays

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

 

 

 

Highlighted
New Member

Re: PREVIOUSDAY for workdays

Thank you, I´m going to try it.

 

AN

Highlighted
Super User II
Super User II

Re: PREVIOUSDAY for workdays

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?






Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
www.linkedin.com/in/danebelarminocpa
Highlighted
New Member

Re: PREVIOUSDAY for workdays

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Top Solution Authors