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,
In the below file, I'm trying to find when two times match when they have different dates. I have tried to separate the times from the dates as you can see below (Actual Cut Off Time and Cut Off Time are formatted as just Time) and done an If formula for seeing when these match, but as you can see on the fifth row this isn't working. I'm assuming it's because dates are still attached in the background - can I separate them?
Thanks!
Solved! Go to Solution.
just extract the time as a calculated colunm
you will get a datetime colunm where the date is always the 31/12/1899 followed by the time
this can tehn be formated to time only and will calculate correctly
Proud to be a Super User!
just extract the time as a calculated colunm
you will get a datetime colunm where the date is always the 31/12/1899 followed by the time
this can tehn be formated to time only and will calculate correctly
Proud to be a Super User!
Thank you!
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 |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |