Forum Discussion
Solved
Power Query Editor custom column correct, but not when apply to model
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 Tim...
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.