Reply
Visitor
Posts: 1
Registered: ‎01-10-2019

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

Established Member
Posts: 203
Registered: ‎07-12-2017

Re: Days Since today

Hi @CBFCHO

 

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

 

 

Regards

Affan

New Contributor
Posts: 426
Registered: ‎04-14-2018

Re: Days Since today

@CBFCHO

 

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" )
)
Regular Visitor
Posts: 23
Registered: ‎03-29-2018

Re: Days Since today

Hi @CBFCHO,

 

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