Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
User | Count |
---|---|
99 | |
87 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |