Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
95 | |
93 | |
91 | |
75 | |
69 |