I would like to create a virtual table with DAX that includes the following columns:
1- “Matching”: If Table1[id] = Table2[id] then “Matched”, else “Not Matched”
2- “Col 1” from Table 1 & 2
3- “Col 2” from Table 1 &2
4- “Date”
5- “Table” to show with table
I’m unclear about your requirement, if you want to create and display the depicted table.
You can achieve that in Power Query or with a DAX table but, generally speaking, not a virtual table…
Please review this video by Brian, that illustrates it best.
I have merged the two tables in my original model with PQ and added the new custom columns. Still, I was interested in finding other ways, especially when measuring the model’s performance (more like comparing both models).
Apologies for my rushed question. I was looking for a DAX Measure instead of a DAX table to maintain the file size. I planned to utilize the measure, to derive calculation based on the new columns.
That said, I will use the above as a foundation and play around to get the result.