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.
Hi there,
I'm still somewhat new to Power BI and have been trying to find a way to calculate differences in two datetime values for two different columns in the same table.
An example of these two datetime columns would be a shipping and receiving date.
Any help would be appreciated.
Solved! Go to Solution.
Try this.... by adding a new column...
DaysDiff = DATEDIFF('DateDiff'[ShippingDate],'DateDiff'[ReceivedDate],DAY)
Proud to be a PBI Community Champion
Try this.... by adding a new column...
DaysDiff = DATEDIFF('DateDiff'[ShippingDate],'DateDiff'[ReceivedDate],DAY)
Proud to be a PBI Community Champion
Ah, I subsequently just discovered that I need to create a calculated column in the case that I use values that transcend actual measures. I appreciate your help, but my issue is resolved.
Thanks
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |