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.
Hello,
I have 3 tables which contains similar data with month/year and some blank/zero value.
I'd like to combine them as single table.
What is the best way to achive this?
Thanks,
desired output
Solved! Go to Solution.
You can either merge queries (2x) in PowerQuery, or you can try create a table with DAX. Something like:
CombinedTable = ADDCOLUMNS(Table1, "Actual1", RELATED(Table2[Actual1]), "Actual2", RELATED(Table3[Actual2]))
(the above dax would only work if there's a relationship between the date columns)
You can either merge queries (2x) in PowerQuery, or you can try create a table with DAX. Something like:
CombinedTable = ADDCOLUMNS(Table1, "Actual1", RELATED(Table2[Actual1]), "Actual2", RELATED(Table3[Actual2]))
(the above dax would only work if there's a relationship between the date columns)
Using power query, load each of the 3 tables and set so they don't load
modify each table so it has a "type" column. Ie the first table will be type = Plan, second will be Actual1, etc. you do this by adding a custom column and set the value of the column to the type
rename the data column to be called "value". All 3 tables must have exactly the same column names
append the 3 tables together and load.
you can then build the output you want from this final loaded table.
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |