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
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
Solved! Go to Solution.
Also simple in Powe BI. Given an [Acknowledged] column in Date format, create a new calculated column with the formula:
Delivery Due = [Acknowledged] - 1
Also simple in Powe BI. Given an [Acknowledged] column in Date format, create a new calculated column with the formula:
Delivery Due = [Acknowledged] - 1
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
90 | |
83 | |
76 | |
64 |
User | Count |
---|---|
142 | |
112 | |
98 | |
98 | |
94 |