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 all,
I have the following problem.
I have 2 tables/databases and would like to ad the values here.
The tables are built the same only with the difference that I have partly different values in it.
Here once an example:
but currently only this is displayed:
How do I get the visual to show everything and not filter on the same number (4 and 5)?
Thanks already once for your help
Gr Pascal
Solved! Go to Solution.
Hi @PascalCLE
You can merge them in power query, you can put the following code in Advanced Editor in power query
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTJSitWJBpI6SmZgljGQZQpmmQBZFmCWKZBlDmYBGQbYGLEA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Table1 = _t, Qty1 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Table1", Int64.Type}, {"Qty1", Int64.Type}}),
#"Merged Queries" = Table.NestedJoin(#"Changed Type", {"Table1"}, #"Table (2)", {"Table"}, "Table (2)", JoinKind.FullOuter),
#"Expanded Table (2)" = Table.ExpandTableColumn(#"Merged Queries", "Table (2)", {"Table", "Qty"}, {"Table (2).Table", "Table (2).Qty"}),
#"Sorted Rows" = Table.Sort(#"Expanded Table (2)",{{"Table1", Order.Ascending}})
in
#"Sorted Rows"
Then create a measure in the new table
Measure = SUM('Table (3)'[Qty1])+SUM('Table (3)'[Table (2).Qty])
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @PascalCLE
You can merge them in power query, you can put the following code in Advanced Editor in power query
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTJSitWJBpI6SmZgljGQZQpmmQBZFmCWKZBlDmYBGQbYGLEA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Table1 = _t, Qty1 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Table1", Int64.Type}, {"Qty1", Int64.Type}}),
#"Merged Queries" = Table.NestedJoin(#"Changed Type", {"Table1"}, #"Table (2)", {"Table"}, "Table (2)", JoinKind.FullOuter),
#"Expanded Table (2)" = Table.ExpandTableColumn(#"Merged Queries", "Table (2)", {"Table", "Qty"}, {"Table (2).Table", "Table (2).Qty"}),
#"Sorted Rows" = Table.Sort(#"Expanded Table (2)",{{"Table1", Order.Ascending}})
in
#"Sorted Rows"
Then create a measure in the new table
Measure = SUM('Table (3)'[Qty1])+SUM('Table (3)'[Table (2).Qty])
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Unfortunately, this is not the solution to the problem.
Simply appending at the bottom does not work in this case because I need to see both the one and the other value as shown in the example.
I have obtained the results by Measure.
Tabel 1 I get the Qty duch a Datumsfilder the 6 monarte in the past looks and Tabel 2 in that I look in the future.
But I must have the sum of both measures.
this also works in principle with :
Proposition 3 =
MAX(0 ,[Proposal]) + MAX(0, [Proposal 2])
But I am just missing the other values as I have already written
In this case, if they are calculated maybe a combination of UNION (https://learn.microsoft.com/es-es/dax/union-function-dax) and some table manipulation function would work
Hi @PascalCLE
Since both tables have the same structure, why don't you append them in Power Query Editor? And then, you sum
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |