Forum Discussion
How to compare same rows in a table
I wish to compare values presented on the same row in a table and only filter out the rows that differs.
This solved my problem:
= [GUID] <> [#"2022-04-30.GUID"] or [StoreyName] <> [#"2022-04-30.StoreyName"]
Hi Anonymous
I think you can use power query to merge the two table，then press close & apply
then add a column to compare the two column
like if（【2022-04-30】 = 【2022-04-22】，1，0）
then filter the data by click the arrow on the column
Best Regards,
Community Support Team _Isabella
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This solved my problem:
= [GUID] <> [#"2022-04-30.GUID"] or [StoreyName] <> [#"2022-04-30.StoreyName"]