cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kevthebandit Regular Visitor
Regular Visitor

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

Accepted Solutions
Super User
Super User

Re: How to create an aggregated table from an existing table

SUMMARIZE

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

 

?


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

Proud to be a Datanaut!


5 REPLIES 5
Super User
Super User

Re: How to create an aggregated table from an existing table

SUMMARIZE

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

 

?


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

Proud to be a Datanaut!


Kevthebandit Regular Visitor
Regular Visitor

Re: How to create an aggregated table from an existing table

Thank you. 

chronis69 Member
Member

Re: How to create an aggregated table from an existing table

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

 

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

 

thank you

Highlighted
Kevthebandit Regular Visitor
Regular Visitor

Re: How to create an aggregated table from an existing table

Modeling > New Table > Formula Bar

 

Modeling New Table.PNG

chronis69 Member
Member

Re: How to create an aggregated table from an existing table

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

 

:-)