how to build a table?

Question

I have a table like the following format.YearNo&nbsp; &nbsp; Customer&nbsp; &nbsp; SalesAmount2023&nbsp; &nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10002023&nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15002023&nbsp; &nbsp; &nbsp; &nbsp; C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8002024&nbsp; &nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12002024&nbsp; &nbsp; &nbsp; &nbsp; C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6002024&nbsp; &nbsp; &nbsp; &nbsp; D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 500&nbsp;and I would like to create a table as the followingCustomer&nbsp; &nbsp;SalesDiffA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-1500C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-200D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500&nbsp;Thanks.

ryan_mayu · Accepted Answer

jiangxm80&nbsp;
pls try this

Table 2 =
SUMMARIZE('Table','Table'[Customer],"salesdiff",CALCULATE(sum('Table'[SalesAmount]),'Table'[YearNo]="2024")-cALCULATE(sum('Table'[SalesAmount]),'Table'[YearNo]="2023"))
&nbsp;

&nbsp;
pls see the attachment below

Forum Discussion

how to build a table?

1 Reply

Related content

Build Availability Table

Centralize table refresh in Semantic Model Build

Build 2.151.1182.0 Error

Building a Fee payment table

Lakehouse Build