Forum Discussion

lboldrino's avatar
lboldrino
Icon for Resolver I rankResolver I
5 years ago
Solved

Summerize DistinctCount by date

  how can i caclute the bookingdays sum of my distinct sprint_Days?? how can i take this Result: thanx for your Idee!  Best Greetings  
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    lboldrino , Try like

    sumx(summarize(Table, Table[sprint_nr], Table[employee], "_1",DistinctCount(Table[String_day])),[_1])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

lboldrino , Try like

sumx(summarize(Table, Table[sprint_nr], Table[employee], "_1",DistinctCount(Table[String_day])),[_1])