Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
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!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |