Forum Discussion

A_a_a's avatar
A_a_a
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 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.

 

Need Help
  • Adescrit's avatar
    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.

2 Replies

  • Adescrit's avatar
    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.