Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
How can i get the sum duration for each Id on the different date and shifts?
Thanks
SUMMARIZE(Table_Shifts , ROLLUP( [shift date], [shift type],[I'd]) , "Duration", SUM(Table_Shifts[Duration]) )
Hello @Anonymous , what am i missing?
Hi @JoeyI
As suggested by az38, please add columns in a matrix.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @v-juanli-msft ,
What i wanted to do was get them by Date/shift and use the resulting values in a measure.
Hello @v-juanli-msft ,
I have added a matrix on the report as you asked.
But i dont require it on my report. wanted to apply a measure on it before reporting the resulting figures
the easiest way is to create a matrix visual, add Date and Shift as rows, Shift Time as columns, Duration as Values (check if it is aggregated as Sum)
then in matrix settings set Row headers - Stepped Layout = Off, then Row subtotals = Off
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
101 | |
68 | |
68 | |
43 |
User | Count |
---|---|
146 | |
106 | |
105 | |
90 | |
65 |