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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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


Follow on LinkedIn
@ 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!:
Power BI Cookbook Third Edition (Color)

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


Follow on LinkedIn
@ 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!:
Power BI Cookbook Third Edition (Color)

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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