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

Roll up Table from Tabular form to Pivot using DAX or Matrix

Hi Power Geeks,

I need a Pivot table based on the above Tabular form to roll up on Levels for each PRICECALCID

Basically LEVEL 0 is the sum of Level 1 and Packaging cost per unit is the sum of cost prices od Descriptions BOM,Process,Surcharge.

Pivot.JPG

And 

Here is the 1st tables looks like:

 Tabular form1.JPG

Please help in generating a  pivot table report and linking 1st table to this new pivot table

3 REPLIES 3
Community Support Team
Community Support Team

Re: Roll up Table from Tabular form to Pivot using DAX or Matrix

@sandeepk66,

 

Basically, you will use the Matrix visual, but might need to create a calculated table first.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sandeepk66 Regular Visitor
Regular Visitor

Re: Roll up Table from Tabular form to Pivot using DAX or Matrix

How to  create a calculated table first to achiebe this is MAtrix, Can you show up a Mockup?

Community Support Team
Community Support Team

Re: Roll up Table from Tabular form to Pivot using DAX or Matrix

@sandeepk66,

 

The sample data in picture above is not very precise. Share us an accurate simplified model.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors