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.
Hello Community,
I am looking for a way to find the difference between two dates.
I tried te following example: Date1 - Date2
This does not give me the difference... this gives me a weird date value.
I tried to use DATEDIFF, but it does not work because Date 2 can have a lower date then date 1.
What are other options I can use?
Solved! Go to Solution.
There was just a recent thread on this. Depending on what you need to do there are several solutions.
My quick solution:
diff = 1.0*([Closed]-[TransactionDate])
Use this code in a new column:
how would this look if you want to calculate the average for eg products?
and how would this look if the dates are on two different columns?
thank you in advance,
Niki
There was just a recent thread on this. Depending on what you need to do there are several solutions.
My quick solution:
diff = 1.0*([Closed]-[TransactionDate])
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |