Problem with Accumulated

[rmolinajr]

Hi!

I'm with problem in filter to o accumulated, need filter the accumulated to get the month previous of month chosen by the filter.

This is the code used to do the accumulated.

CALCULATE(
SUM([VALOR]);
FILTER(
ALLSELECTED('DIM_DATA'[DIA]);
ISONORAFTER('DIM_DATA'[DIA]; MAX('DIM_DATA'[DIA]); DESC)
)
)

This get the month current.

Thank you!

[Anonymous]

@rmolinajr,

What fields do you use to create the visual and what fields do you use to create the filter?

In your scenario, do you get expected result when creating a new measure with the DAX below? If not, please describe your desired result with sample data.

Measure= CALCULATE([Accumulated],DATEADD('DIM_DATA'[DIA],-1,MONTH))

Regards,
Lydia