Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jimpatel
Post Patron
Post Patron

date add

‎05-09-2024 01:42 AM

Hi,

 

Thanks for looking at my post.

 

I have below formula and can anyone help me to modify this to add 2 days on top of this please?

 

 Date = SWITCH(TRUE(),
         WEEKDAY( 'Table'[ReceiptDate] + 1,1) = 7 , 'Table'[ReceiptDate] + 3, 'Table'[ReceiptDate] + 0
)
Message 1 of 3
295 Views
0
1 ACCEPTED SOLUTION
Elcin_7
Helper I
Helper I

‎05-09-2024 02:30 AM
Hi,
 
Date  = SWITCH(
            TRUE(),
            WEEKDAY( 'Table'[ReceiptDate] + 1,1) = 7 , 'Table'[ReceiptDate] + 3+2, 'Table'[ReceiptDate] + 0+2
)
 
another version
 
Date  = SWITCH(
            TRUE(),
            WEEKDAY( 'Table'[ReceiptDate] + 1,1) = 7 , 'Table'[ReceiptDate] +5, 'Table'[ReceiptDate] + 2
)
 
I hope, I understood the requirement correct.

View solution in original post

Message 2 of 3
280 Views
2 REPLIES 2
jimpatel
Post Patron
Post Patron

‎05-09-2024 03:07 AM

Perfect

 

Thanks a lot 

Message 3 of 3
275 Views
0
Elcin_7
Helper I
Helper I

‎05-09-2024 02:30 AM
Hi,
 
Date  = SWITCH(
            TRUE(),
            WEEKDAY( 'Table'[ReceiptDate] + 1,1) = 7 , 'Table'[ReceiptDate] + 3+2, 'Table'[ReceiptDate] + 0+2
)
 
another version
 
Date  = SWITCH(
            TRUE(),
            WEEKDAY( 'Table'[ReceiptDate] + 1,1) = 7 , 'Table'[ReceiptDate] +5, 'Table'[ReceiptDate] + 2
)
 
I hope, I understood the requirement correct.
Message 2 of 3
281 Views

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

View All