cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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.

 

 

Regards

Affan

themistoklis Memorable Member
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" )
)
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 )
    )
)

Regards

Chiara

 

Helpful resources

Announcements
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