cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kevthebandit
Helper II
Helper II

How to create an aggregated table from an existing table

Hello, 

 

I can create a calculated table from 1 field from an existing table, but how can I incorporate more fields from the same table?

 

I am trying to create an aggregate or summary high level table with distinct columns and summed measure values. 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User IV
Super User IV

SUMMARIZE

https://msdn.microsoft.com/en-us/library/gg492171.aspx?f=255&MSPPError=-2147217396

 

?


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




View solution in original post

5 REPLIES 5
Greg_Deckler
Super User IV
Super User IV

SUMMARIZE

https://msdn.microsoft.com/en-us/library/gg492171.aspx?f=255&MSPPError=-2147217396

 

?


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




View solution in original post

Thank you. 

Anonymous
Not applicable

excuse my ignorance, but where exactly is this DAX command issued?

 

a new meassure? a new column? a new query?

 

thank you

Modeling > New Table > Formula Bar

 

Modeling New Table.PNG

Anonymous
Not applicable

thanks... of all the "new" objects one can create I have missed the new table... 

 

🙂

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

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

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.