## Desktop

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