Forum Discussion

ctedesco3307's avatar
ctedesco3307
Resolver II
4 years ago
Solved

Table.Group by aggregate from a RELATED column

I have a MSSDates table that has a relationship with my calendar table.  The MSSDates table has a RELATED column in it to identify the day as a working day or not,   I want to create a summary table ...
Need Help
  • ctedesco3307's avatar
    ctedesco3307
    4 years ago

    GOT IT! take out the second SUM

     

    Table = GROUPBY(MSSFlatFeeDates,MSSFlatFeeDates[Opportunity],"TotalDays",SUMX(CURRENTGROUP(),MSSFlatFeeDates[WorkingDay]))
ctedesco3307's avatar
ctedesco3307
Resolver II
4 years ago

So - I got this far- but I'm not getting the right number - there should be 252 - 254 value (working days in a year) for each opportunity. Any pointers? thx in advance 

Table = GROUPBY(MSSFlatFeeDates,MSSFlatFeeDates[Opportunity],"TotalDays",SUMX(CURRENTGROUP(),SUM(MSSFlatFeeDates[WorkingDay])))