Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |