Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

View Upcoming Due Dates Only Weekdays

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.

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Anonymous,

     

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks Anonymous 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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI Anonymous,

         

        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