Forum Discussion
Floating cumulative sum
- 3 years ago
I build a example with your infos. I think the problem is your automatic time intelligence.
For example: If you use the automatic time intelligence filter: blue one the filtering is correct. If you use the regular date column it not work. The time intelligence is like a hidden dimension table for the date. (please correct me someone if its wrong).
starting point:blue filtering (date - year):
The same via date (red). You see the cummlative has no filter.
The reason is, that you use ALL() in your DAX expression and the measure line ignore your filter (via selection the regular date column!) from the fact table. If you use the "hidden" dimension table filter via other fields the complete table is filtered for both (measure and column).
Can you please give the complete DAX statement of:
I created DAX statement:
dat_prov = date of prov
Hi,
sorry I used the wrong interpretation. Column "dat_prov" is regular column from imported table "Krist":
In power query I just changed the type to date and then transformed all the date into start of the month