Forum Discussion

rmolinajr's avatar
rmolinajr
Frequent Visitor
8 years ago

Problem with Accumulated

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!

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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