Create a new table from existing one

Hello,

1) Create measure Sum_Values=Sum([Values])
2) add matrix/table visualisation and add the field how at screenshot
3) After that you need - right click at "Allowance" and click "W/o calculation"

If for some reason you want to create another table (calculated) and not visual...

Add helper column to source table (Table1).

YRQ = [Year] & "-" & [Quarter]

Then in Modeling tab, add New Table

Table2 = DISTINCT(Table1[YRQ])

Build relationship between YRQ column of each table.

Add columns.

For Values:

Values = SUMX(FILTER(Table1,Table1[YRQ]=Table2[YRQ]),[Values])

For Allowance: (Same construct for Year & Quarter, just change the column reference for last argument)

Allowance = MINX(FILTER(Table1,Table1[YRQ]=Table2[YRQ]),Table1[Allowance])