Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I am having some trouble with figuring out a formula to display my upcoming order due dates, specifically I want to view the next 5 order dates due but only if they fall on a weekday. I am also trying to build a column which shows all upcoming due dates for the next working week.
For the above, my due 1+ - 5+ would be returning M-F next week (10/30-11/3) as of today and on Monday 10/30 I would want to return T-M (10/31-11/6) and so on.
For the Upcoming week, I would be returning M-F (11/6-11/10) as of now, and advancing in a similar fashion as the Day 1+-5+>
Here is an example file - example.pbix
Any and all help is greatly appreciated.
HI @adamnimmo,
You can try to use below measure to get Current weekday range and upcoming weekday range:
Current/Upcoming Week = VAR temp = [PastDue_Adj] VAR weekDay = WEEKDAY ( temp, 1 ) VAR CurrentWeek = temp + 7 + ( 2 - weekDay ) & "~" & temp + 7 + ( 6 - weekDay ) VAR UpcomingWeek = TODAY () + 7 + ( 2 - WEEKDAY ( TODAY (), 1 ) ) & "~" & TODAY () + 7 + ( 6 - WEEKDAY ( TODAY (), 1 ) ) RETURN IF ( temp <> BLANK (), CurrentWeek, IF ( [DeliveredLate] <> 1, UpcomingWeek ) )
Regards,
Xiaoxin Sheng
Thanks @v-shex-msft however it's not quite what I was hoping to achieve. Ideally I am wanting to only display in the Day 1-5 upcoming orders for weekdays and on the Upcoming Due display the upcoming weeks orders.
HI @adamnimmo,
Which date you used check as the condition to switch the date range? If you can please use the static date value. It may get the wrong result if you combine use multiple measures who contains specific filters.
Regards,
Xiaoxin Sheng
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
77 | |
60 | |
52 |
User | Count |
---|---|
165 | |
86 | |
68 | |
68 | |
58 |