https://community.fabric.microsoft.com/t5/Desktop/Add-rows-to-table-according-to-grouping-in-different-table/m-p/390407
Solved: Re: Add rows to table according to grouping in dif... - Microsoft Fabric Community
Apr 6, 2018 - Try with this code New Table = VAR Mytable1 = ADDCOLUMNS ( Table1, "My Group", CALCULATE ( FIRSTNONBLANK ( Table2[Group], 1 ) ) ) VAR
add rows to table