cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## 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

3 REPLIES 3
Solution Sage

## Re: Days Since today

Hi @Anonymous

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

Regards

Affan

Memorable Member

## Re: Days Since today

@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" )
)```
Resolver II

## Re: Days Since today

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

Announcements

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors