Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
NetBoulter
Frequent Visitor

Subtract 1 working day from Date Column

I'm new so please bear with me. 

 

I have data coming in from csv (dumped from database so I don't want to do the calculation in the csv).

 

One of the columns is "Acknowledged" date. I need to calculate the "Delivery Due" date, which is the "Acknowledged" date less 1 working day. 

 

Obviously simple in Excel and will be simple for you experts but I am lost, have searched the e-learning and the community and can't find anything that I can work from. 

 

PS the reason I am not connecting direct do Database is that it is a bespoke one and I'll attack the how to do that at a later date!

 

Thanking you in advance

NetB

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Also simple in Powe BI. Given an [Acknowledged] column in Date format, create a new calculated column with the formula:

 

Delivery Due = [Acknowledged] - 1

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

Also simple in Powe BI. Given an [Acknowledged] column in Date format, create a new calculated column with the formula:

 

Delivery Due = [Acknowledged] - 1

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Hello,

 

What if the number of days to subtract or add is variable, so there is a column to add or subtract, would it be as simple as [Date] + [Column with number of Days]?

 

BI simply does not accept this procedure.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.