cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
A_a_a
Helper II
Helper II

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
Solution Specialist
Solution Specialist

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
Solution Specialist
Solution Specialist

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors