Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |