Forum Discussion
tomekm
3 years agoHelper III
Compute changes for the same attribute, when comparing 2 Periods selected by the user in a filter
Hello, I’m trying to come up with a DAX formula or data modelling option that will compute changes for the same attribute, when comparing 2 Periods selected by the user in a filter. The same valu...
CNENFRNL
3 years agoCommunity Champion
- tomekm3 years agoHelper III
Thanks for the response; the formula works only partially. The problem/limitations now are that the formula is also labelling as False new entries that are present in current Period that were not existing in the previous Period. Those should be ignored, and only entries present in both Periods should be considered for analysis.
Also, there’s a missing dynamic Periods filter, needed to be able to pick the starting period and ending period (for example if I want to compare Period two to Period eight.
Finally, how do I only show the False rows, and not the whole table? The measure cant be added as filter.
Thank you.