cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Allan77
New Member

Changing Data Structure

I am trying to take my data from the structure in pic1 to the structure in pic2. Would anyone be able to point me in the right direct to accomplish this?

pic 1.jpgpic 2.jpg

1 ACCEPTED SOLUTION

Thats awesome, thanks for your help!

View solution in original post

4 REPLIES 4
mattbrice
Solution Sage
Solution Sage

You want that in a visual?  then just put 'Service' in columns, 'Date' in rows.

 

You want that in the data model?  Then you need to look at the Query Editor, Transform, Pivot Column step.

 

But your pic1 structure is ideal for Data Modeling/Dax...

I have found that pic 1 data structure is restictive. By examply if I want to do a measure to sum up all Service 1 totals it wouldnt work as it wants a column name. Maybe Im missing something?

 

The structure in  pic 2 is the data structure that I thought I needed and not what I want in a visual.

 

Thanks

 

Dax filters works on columns so the below is what you would do. 

 

Service 1 Total =
CALCULATE ( SUM ( Table[Value] ), Table[Service] = "Service1" )

Thats awesome, thanks for your help!

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!