Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have merged two tables table 1 & 2 to Table 1 and now I want to comapare two columns containing similar data and to display if both values are equal or not.
here is the sample Input and output -
Could you please help me out on this.
Thanks,
Rohith
Solved! Go to Solution.
hi,
not sure i'm getting your question right but if you need to get what's in the New Column here's the formula"
= if [C2PC Status] = [MSX Status] then "In Sync" else "Out of Sync"
hope this helps,
radpir
hi,
not sure i'm getting your question right but if you need to get what's in the New Column here's the formula"
= if [C2PC Status] = [MSX Status] then "In Sync" else "Out of Sync"
hope this helps,
radpir
Hey Radpir, Suppose if you want a more complex scenario where you have to compare two columns of your active workbook with two columns residing in many Excel files in a folder having the same structure, how would you pull the data then. I believe an "AND" operator would do the trick but I have not been able to figure it out so far. By the way, I am using Excel 2016 Power Query. I also believe that since Power Query and BI have many similarities, my question can be answered here.
Hey Radpir, Suppose if you want a more complex scenario where you have to compare two columns of your active workbook with two columns residing in many Excel files in a folder having the same structure, how would you pull the data then. I believe an "AND" operator would do the trick but I have not been able to figure it out so far. By the way, I am using Excel 2016 Power Query. I also believe that since Power Query and BI have many similarities, my question can be answered here.
Just what i needed Thanks a ton Radpir!
Regards,
Rohith
User | Count |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
96 | |
92 | |
91 | |
75 | |
69 |