Forum Discussion

Feilin's avatar
Feilin
Helper II
8 years ago
Solved

Aggregate rows on months with DAX

I'm trying to aggregate a month value as a calculated column, but I'm struggling a bit how I should filter it. I have the following:   Month Time = CALCULATE( SUM( Dates[Time to be Agg...
Need Help
Show and Tell
  • alexei7's avatar
    alexei7
    8 years ago

    I'm probably not going to do it justice, but my understanding is that it's like the ALL function, which would remove all filter context (i.e. would sum everything in the table), except it keep the month as the filter context. Therefore, each row is totalled based on what is in the month column.

     

    I'm afraid i didnt understand your first question, you'll need to provide more data to show what you mean by these other different columns.

     

    Thanks

alexei7's avatar
alexei7
Continued Contributor
8 years ago

I'm probably not going to do it justice, but my understanding is that it's like the ALL function, which would remove all filter context (i.e. would sum everything in the table), except it keep the month as the filter context. Therefore, each row is totalled based on what is in the month column.

 

I'm afraid i didnt understand your first question, you'll need to provide more data to show what you mean by these other different columns.

 

Thanks

Feilin's avatar
Feilin
Helper II
8 years ago

Oh, silly me. I just needed to except the Year as well, and it worked (it was the same number of years as additional columns, so I misinterpreted the results).

 

Now it works, thanks!