Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi all ,
I have table similar to the below.
I need to have have column that check if column 2 & 3 are identical - easy
I also need to have column that show the differnce between the columns
e.g.
1 identical
2 A - missing A
3 A - additional A
4 - , - additional ,
5 - space
is it possible to acheive with PQ / DAX ?
Column1Column2Column3
1 | AAA | AAA |
2 | AAA | AA |
3 | AAA | AAAA |
4 | AB | AB, |
5 | AAA | A A |
Solved! Go to Solution.
Hi @nirrobi,
You can add a custom column in Query Editor:
if ([Column1] = [Column2]) then "identical" else if (Text.Length([Column1]) > Text.Length([Column2])) then Text.Replace([Column1], [Column2], "") &"- missing "& Text.Replace([Column1], [Column2], "") else if (Text.Length([Column1]) < Text.Length([Column2])) then Text.Replace([Column2], [Column1], "") &"- additional "& Text.Replace([Column2], [Column1], "") else ""
This solves everything except point 5 in your example, but it's a good approach.
Regards.
Hi @nirrobi,
You can add a custom column in Query Editor:
if ([Column1] = [Column2]) then "identical" else if (Text.Length([Column1]) > Text.Length([Column2])) then Text.Replace([Column1], [Column2], "") &"- missing "& Text.Replace([Column1], [Column2], "") else if (Text.Length([Column1]) < Text.Length([Column2])) then Text.Replace([Column2], [Column1], "") &"- additional "& Text.Replace([Column2], [Column1], "") else ""
This solves everything except point 5 in your example, but it's a good approach.
Regards.
User | Count |
---|---|
128 | |
73 | |
70 | |
58 | |
53 |
User | Count |
---|---|
193 | |
96 | |
66 | |
62 | |
52 |