Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
A_a_a
Helper III
Helper III

New calculated table

Hi All,

 

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

Table 1

A_a_a_0-1686555083598.png

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

Table 2

A_a_a_2-1686555352264.png

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

 

1 ACCEPTED SOLUTION
Adescrit
Impactful Individual
Impactful Individual

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.


Did I answer your question? Mark my post as a solution!
My LinkedIn

View solution in original post

2 REPLIES 2
Adescrit
Impactful Individual
Impactful Individual

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.


Did I answer your question? Mark my post as a solution!
My LinkedIn

Hi @Adescrit 

 

Thank you! It works.

 

A_a_a

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors