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 gettng an error when I subtract one date column from another date column in Power Query.
Here is the formula I have to crate my column which subtracts one date column from the other date column
= Table.AddColumn(#"Determine Quick vs Not Quick", "Delivery Date less PO Date", each ([#"Created On (PO)"]-[#"Delivery (from Delivery Dates)"])*1)
Both of the columns are formatted as date columns.
Here is the error I receive after I close Power Query.
Solved! Go to Solution.
Hi @Anonymous,
The calculate between two date fields should be a duration, you can't direct convert it to date type. I'd like to suggest you use the duration type to store the result.
After these steps, you can simply use duration functions to extract different units from duration value. (such as day, hour, minutes...)
AddColumn= Table.AddColumn(#"Changed Type", "Custom", each Duration.From([End]-[Start]))
Regards,
Xiaoxin Sheng
Hi @Anonymous,
The calculate between two date fields should be a duration, you can't direct convert it to date type. I'd like to suggest you use the duration type to store the result.
After these steps, you can simply use duration functions to extract different units from duration value. (such as day, hour, minutes...)
AddColumn= Table.AddColumn(#"Changed Type", "Custom", each Duration.From([End]-[Start]))
Regards,
Xiaoxin Sheng
Sample data would really help to recreate this but it seems like you are changinge that column to a Date column, but a subtraction between two dates will not result in a date, it would result in the number of days, a whole number value?
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 |
---|---|
112 | |
100 | |
76 | |
64 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
80 | |
67 |