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'm simply trying to relate column C from "Native Load 2019" with the other excel file "DART 2019 with correct Date_Example" so that the correct values align with the correct date/time. I've tried doing this in Power BI by manipulating the date formats and creating a relationship on them but am struggling. At first I tried sharing my Power BI but I think it may be easier to just supply you with the excel sheets so that you can work thorugh the relationship from scratch.
Thanks in advance, I'll appreciate any support you can give!
Solved! Go to Solution.
Hi @Anonymous ,
The issue is that you can't convert [HourEnding] column in 'Native Load Report' table from "Text" to "Date/Time", right?
If so, try this:
1. In Power Query Editor, replace "24:00" with "00:00".
2. Change data type.
3. Close and Apply.
4. In Power BI Desktop relationship view, you can create relationships now.
BTW, .pbix file attached.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
The issue is that you can't convert [HourEnding] column in 'Native Load Report' table from "Text" to "Date/Time", right?
If so, try this:
1. In Power Query Editor, replace "24:00" with "00:00".
2. Change data type.
3. Close and Apply.
4. In Power BI Desktop relationship view, you can create relationships now.
BTW, .pbix file attached.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
109 | |
101 | |
86 | |
77 | |
69 |
User | Count |
---|---|
120 | |
108 | |
98 | |
83 | |
77 |