Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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]))
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
20 | |
17 | |
11 | |
10 | |
10 |
User | Count |
---|---|
31 | |
25 | |
15 | |
13 | |
12 |