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,
I have 3 columns in Excel > Start, Finish and Difference
When I import the excel i get errors with the times in Power BI.
What I want to do is list all differences that exceeds 4 hours.
Example:
Start - Finish - Difference
15:00 - 17:00 - 02:00
15:00 - 17:30 - 02:30
16:00 - 20:05 - 04:05
17:00 - 23:00 - 06:00
So, how do I import the excel spreadsheet without getting errors? I guess I can just filter the min of "Difference" column to show only greater than 04:00 hours?
Solved! Go to Solution.
Hi Will90,
See these images. (My Excel is setting in Spanish, sorry)
You always have to change houre format in PBI
Tell us your results.
Hi Will90,
See these images. (My Excel is setting in Spanish, sorry)
You always have to change houre format in PBI
Tell us your results.
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |