cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

2 ACCEPTED SOLUTIONS
Resolver III

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

New Member

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

4 REPLIES 4
Super User

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."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
New Member

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

Resolver III

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

New Member

Thank you, I´m going to try it.

AN

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors