Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Days Since today

Hi,

I new to PBI and am in need of a little help

I currently have a chart that shows all orders raised Yesterday.

This works great, however on a monday I would like yesterday to include Friday- Saturday and Sunday as one day

any help would be great

thank you

Need Help

3 Replies

  • affan's avatar
    affan
    Solution Sage
    7 years ago

    Hi Anonymous

     

    Can you share some data for better understanding. Please go through this post to get your issue resolved fast.

     

     

    Regards

    Affan

  • themistoklis's avatar
    themistoklis
    Community Champion
    7 years ago

    Anonymous

     

    Maybe a formula like the following could help.

     

    This is a calculated column which returns the DayNames of the week Mon, Tue, Wed, Thu, Combined_Date

    Combined_Date includes Friday, Saturday and Sunday.

    When today's date is Monday it shows the daynames with the combined date otherwise all 7 daynames of the week.

     

    You should then add tis column to the chart

     

    I hope it makes sense:

     

    Calculated Column =
IF (
    FORMAT ( TODAY (), "DDD" ) = "Mon"
        && FORMAT ( Table[Date], "DDD" ) IN { "Fri", "Sat", "Sun" },
    "Combined_Date",
    FORMAT ( Table[Date], "DDD" )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous,

     

    try with this:

     

    OrderRaisedYesterday :=
IF (
    WEEKDAY ( TODAY (), 2 ) = 1,
    (
        CALCULATE ( [Order], Calendar[Date] = TODAY () - 1 )
            + CALCULATE ( [Order], Calendar[Date] = TODAY () - 2 )
            + CALCULATE ( [Order], Calendar[Date] = TODAY () - 3 )
    ),
    (
        CALCULATE ( [Order], Calendar[Date] = TODAY () - 1 )
    )
)

    Regards

    Chiara