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.
how can i caclute the bookingdays sum of my distinct sprint_Days??
how can i take this Result:
thanx for your Idee!
Best Greetings
Solved! Go to Solution.
@lboldrino , Try like
sumx(summarize(Table, Table[sprint_nr], Table[employee], "_1",DistinctCount(Table[String_day])),[_1])
@lboldrino , Try like
sumx(summarize(Table, Table[sprint_nr], Table[employee], "_1",DistinctCount(Table[String_day])),[_1])
@lboldrino , In this case , this should work
DistinctCount(Table[String])
Ii need to sum Bookingdays pro sprints:
User | Count |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |