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.
Hello wonderful community, I will try my best to be brief in this request.
For simplicity, I have a table below (the table name is WorkCentre220) that I have filtered Week Number = 38 and Year = 2022. The total sum of Required Hours under these filters is 98.698 (98.70 round off)
Challenge:
I want to return a new table using GROUPBY function that group [Week Number] and [Year] into a single row and sum the total value of column [Required Hours] into One Row.
I have worked out the DAX formula to return the table but can't quite figure out how to finish this:
Expected Results:
Week Number | Year | Total Required Hours by Week and Year |
38 | 2022 | 98.70 |
39 | 2022 | 264.90 |
40 | 2022 | 94.90 |
I'd really appreciate if someone could help me please.
Thanks everyone and have a wonderful day!
Solved! Go to Solution.
Hi wonderful community, I have figured it out!!
Use SUMMARIZE instead of GROUPBY:
NewTable = SUMMARIZE(WorkCentre220,WorkCentre220[5. Week Number],WorkCentre220[6. Year],"Total",SUM(WorkCentre220[3. Required Hours]))
Results:
Hi wonderful community, I have figured it out!!
Use SUMMARIZE instead of GROUPBY:
NewTable = SUMMARIZE(WorkCentre220,WorkCentre220[5. Week Number],WorkCentre220[6. Year],"Total",SUM(WorkCentre220[3. Required Hours]))
Results:
Hi @knafzal01 ,
I am so glad to hear that your problem has been solved . Please consider Accept it as the solution to help the other members find it more quickly.
Best regards,
Yadong Fang
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |