cancel
Showing results for
Did you mean:
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:

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

4 REPLIES 4
Highlighted
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

## 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?

Proud to be a Super User!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
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

Announcements

#### Power Platform Community Conference

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

#### Experience what’s next for Power BI

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

#### Community Summit North America – Join Online!

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

Top Solution Authors
Top Kudoed Authors