Forum Discussion
Solved
Merging columns
Hello, I've a three columns table as follows in Power BI: Item Value 1 Value 2 A String 1 B String 1 String 4 C String 2 D String 3 String 5 E String 1 ...
output :
try this calculated table :
Table 2 =var ds_1 =filter(SUMMARIZE(items,items[Item],items[Value 1]),items[Value 1] <> blank())var ds_2 =filter(SUMMARIZE(items,items[Item],items[Value 2]),items[Value 2] <> blank())
RETURNUNION(ds_1,ds_2)let me know if this helps.
Thanks for the solution ! The only problem is that it's a calculated table from Power BI so I cannot use the Power Query...
output :
try this calculated table :
Table 2 =
var ds_1 =
filter(
SUMMARIZE(
items,
items[Item],
items[Value 1]
),
items[Value 1] <> blank()
)
var ds_2 =
filter(
SUMMARIZE(
items,
items[Item],
items[Value 2]
),
items[Value 2] <> blank()
)
RETURN
UNION(
ds_1,ds_2)
let me know if this helps.