Forum Discussion

Helper III

3 years ago

Solved

New calculated table

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 coun...

Need Help

Adescrit
3 years ago
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.

Adescrit

Impactful Individual

3 years ago

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.