Forum Discussion
Matching Records
Hi Community people, i'm trying to merge 2 datasets with a common field created on purpose: these 2 datasets have the same information but classified differently, hence I created this common fiel...
Hi Anonymous ,
Based on my test using part of your data. I can get all columns by mergeing queries. Please check the attached pbix and source files. You can update the file path in Power query and view the M code.
Hi v-frfei-msft Frank,
sorry for such a late reply but I had to wait until my laptop got replaced with Windows 10 as PBI was unstable with Windows 7.
Coming back to this, it perfectly matches if we merge with QF DATA, but 0 merges with VA data.
the coding query is the reference of QF DATA without all columns but coding. I also try to split this as a new source but when it comes to merge with VA data, 0 matches
any idea why?