Changing Data Structure

[Allan77]

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?

[mattbrice]

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...

[Allan77]

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

[mattbrice]

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

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

[Allan77 · Accepted solution]

Thats awesome, thanks for your help!