Get Summary on two columns of a table as new table (see attached image))

Anything related to PowerPivot and DAX Formuale
sgogisetty
Posts: 1
Joined: Sun Jun 02, 2019 4:08 am

Get Summary on two columns of a table as new table (see attached image))

Postby sgogisetty » Sun Jun 02, 2019 4:14 am

Problem.JPG
Problem.JPG (33.08 KiB) Viewed 231 times


This is simplified version of my problem

Please help with DAX solution for the above problem

PhilC
Posts: 274
Joined: Tue Sep 09, 2014 8:13 am

Re: Get Summary on two columns of a table as new table (see attached image))

Postby PhilC » Sun Jun 02, 2019 1:48 pm

Hi sgogisetty, does the solution have to be soley DAX based on your source table, or can you process using Queries first?

Also, instead of posting a picture of the data and expected output, please post a file, so the data is readily available to work with.

Cheers
Phil


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 4 guests

cron