https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/POWER-BI-Question-on-Tabel-Queries-and-formula-measures/m-p/2725356#M83282 <P>Hi,</P><P>&nbsp;</P><P>I have 2 tables (Table 1 and Table 2)</P><P>I need the result&nbsp;as per below image&nbsp;</P><P><img /></P><P>&nbsp;</P> Thu, 25 Aug 2022 08:22:25 GMT Ival 2022-08-25T08:22:25Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/POWER-BI-Question-on-Tabel-Queries-and-formula-measures/m-p/2725356#M83282 <P>Hi,</P><P>&nbsp;</P><P>I have 2 tables (Table 1 and Table 2)</P><P>I need the result&nbsp;as per below image&nbsp;</P><P><img /></P><P>&nbsp;</P> Thu, 25 Aug 2022 08:22:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/POWER-BI-Question-on-Tabel-Queries-and-formula-measures/m-p/2725356#M83282 Ival 2022-08-25T08:22:25Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/POWER-BI-Question-on-Tabel-Queries-and-formula-measures/m-p/2725728#M83314 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="432250" data-lia-user-login="Ival" class="lia-mention lia-mention-user">Ival</a> , First Append them in Power Query and then use group by in Power Query</P> <P><BR />Append : <A href="https://radacad.com/append-vs-merge-in-power-bi-and-power-query" target="_blank" rel="noopener">https://radacad.com/append-vs-merge-in-power-bi-and-power-query</A></P> <P>&nbsp;</P> <P>Group by</P> <P><A href="https://docs.microsoft.com/en-us/power-query/group-by" target="_blank" rel="noopener">https://docs.microsoft.com/en-us/power-query/group-by</A></P> <P>&nbsp;</P> <P>In DAX</P> <P>&nbsp;</P> <LI-CODE lang="markup">Table = var _tab = Union(Table1,Table2) return GROUPBY(_tab, [Date], [Item], "Total", SUMX(CURRENTGROUP(),[Value]))</LI-CODE> Thu, 25 Aug 2022 10:24:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/POWER-BI-Question-on-Tabel-Queries-and-formula-measures/m-p/2725728#M83314 amitchandak 2022-08-25T10:24:37Z