New calculated table

[A_a_a]

Hi All,

I have a lot of rows from text file, something like that:

Table 1

Based on the data above, I need to create a new summary table to see such details:

Table 2

-distinct count of item

-sum of qty

-sum of orders

-type and size - no calculations

I need that as a new table and then I will create relationship between Item from Table 1 and Item in Table 2.

Is it possible? If yes, how can I do that?

Thanks,

G.

[Adescrit · Accepted solution]

Hi @A_a_a 

You could try the following:

Table 2 = 
  SUMMARIZE( Table1, 
    Table1[Item], 
    Table1[type], 
    Table1[size cm], 
    "qty total", SUM( Table1[qty] ),
    "ordered total", SUM( Table1[ordered] )
  )

You need to select "New Table" from the modelling tab in Power BI desktop, and paste in this code. Edit the table name "Table1" as appropriate.

[A_a_a]

Hi @Adescrit 

Thank you! It works.

A_a_a