Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I have created a custom column in Power Query Editor below which is working perfectly and returning the values that I want.
= Table.AddColumn(#"Changed Type1", "Duration", each if [End Time] > [Start Time]
then [End Time] - [Start Time]
else ([End Time] - Time.FromText ("00:00:00")) + (Time.FromText ("23:59:00") - [Start Time]))
When I close and upload the values in the model table aren't correct and I can't even really understand where they are coming from. They are not all the same but large number of rows are returning the same value.
Any help would be appreciated.
Thanks
Solved! Go to Solution.
In PQ, bottom left, change "profile based on 1000 rows" to "profile based on entire data set". The issue may be coming further in the file processing. Then filter on rows to show the problem records.
In PQ, bottom left, change "profile based on 1000 rows" to "profile based on entire data set". The issue may be coming further in the file processing. Then filter on rows to show the problem records.
Hi Matt
It is always the simple things! Thanks so much - works perfectly.