Compute changes for the same attribute, when comparing 2 Periods selected by the user in a filter

[tomekm]

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 value in column A appears in each Period, but can have a different value in column B. I’m trying to identify those that aren’t the same value. Here’s my example:

Attribute	Sub-attribute	Period
A	x	Jan-2023
A	y	Jan-2023
A	z	Jan-2023
B	w	Jan-2023
C	m	Jan-2023
C	n	Jan-2023
A	x	Feb-2023
A	y	Feb-2023
A	d	Feb-2023
B	s	Feb-2023
C	v	Feb-2023
C	n	Feb-2023

Expected outcome would be a TRUE/FALSE column that will identify which Attributes are changing sub-attributes from period 1 to period 2. (Note that a single Attribute can have more than 1 sub-attribute in any given month; and that the formula should only consider Attributes that appear in both Periods selected for analysis, i.e. don't show as FALSE an Attribute that appeared in Period 2 but wasn't there in Period 1.. Simply ignore it). Expected outcome table:

A	x	TRUE
A	y	TRUE
A	d	FALSE
B	s	FALSE
C	v	FALSE
C	n	TRUE

Thanks a lot.

[CNENFRNL]

[tomekm]

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.