Showing results for 
Search instead for 
Did you mean: 
Not applicable

Days Since today


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

affan Solution Sage
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.





themistoklis Memorable Member
Memorable Member

Re: Days Since today



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" },
    FORMAT ( Table[Date], "DDD" )
Chiara Resolver II
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 )




Helpful resources

Announcing the New Spanish Forum

Announcing the New Spanish Forum

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

April 2020 Community Highlights

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

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors