DAX How many datasets have changed on an ordinal scale?

[Jayshamone]

Hi,

I have a dataset with the following tables:
[Users], [Date], [Tier], [Facts]. The [Fact Table] includes the combination of the three other tables.

The values [Tier]-Table are on an ordinal scale.

The question, I would like to answer is: 

How many users have changed from a lower tier to a higher tier (and vice versa) within one month.

In an example: 

Facts [Date, User, Tier] = {[2021-01-01, 1, 1], [2021-02-01, 1, 2], ....}

Here User 1 has sunken from tier1 to tier2 in the timespan from 2021-01-01 to 2021-02-01. 

How can I define that measure to get the information how many users have sunken and how many have risen?

I included a demo report / dataset.

Thank you. 

[lbendlin]

You want to be more specific.  Within your interval a user may rise and fall multiple times. Are you only interested in the snapshot comparison, or do you want to know the whole story?

What does "within one month" mean?  What is the length of that?  How would you compare February to March against July to August?

Your sample data is a little light.

[Jayshamone]

A snapshot would be enough. Although the number of rises / falls would be even better.

We only have 1 value per user per month - which is always assigned to the first of the month.

So, something like Previousmonth() / dateadd([Date], -1, month) would in principle work - however, I could not get the whole formula to work.