Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I have 2 tables (Table 1 and Table 2)
I need the result as per below image
@Ival , First Append them in Power Query and then use group by in Power Query
Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Group by
https://docs.microsoft.com/en-us/power-query/group-by
In DAX
Table = var _tab = Union(Table1,Table2)
return
GROUPBY(_tab, [Date], [Item], "Total", SUMX(CURRENTGROUP(),[Value]))
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
14 | |
12 | |
12 | |
9 |
User | Count |
---|---|
63 | |
22 | |
21 | |
17 | |
11 |