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.
@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.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!