Forum Discussion
Ambiguity in relationships due to zero values and empty strings
Thank you MFelix, this worked nicely so far. I used the filter option of the column in the query editor. This gave me the follwing code:
= Table.SelectRows(#"Changed Type3", each ([#"Order-ID"] <> null and [#"Order-ID"] <> ""))
This should, in the future when new rows are added with new "Order-IDs" display and include these Order IDs and the repsective Rows, of course unless they are null or "", right?
Super UserHi seabassk,
On the advance query filter out the zero / empty values on the column you are refering and this will filter the information from your Data, so giving the 1st option in your post.
Regards,
MFelix
Thank you MFelix, this worked nicely so far. I used the filter option of the column in the query editor. This gave me the follwing code:
= Table.SelectRows(#"Changed Type3", each ([#"Order-ID"] <> null and [#"Order-ID"] <> ""))
This should, in the future when new rows are added with new "Order-IDs" display and include these Order IDs and the repsective Rows, of course unless they are null or "", right?
- MFelix
Hi seabassk,
This will work in the future also when new rows are added because in the query view you are saving a number of steps that are repeated in a certain order when you update your data source, so when you add the new rows this will continue to remove the null or blanks, it's like a macro.
Regards,
MFelix