Select data based on two date columns

[PowerRon]

Hi

I simplified the problem.
Below the pbix and excel

https://www.dropbox.com/scl/fi/rxg86mc4id414vkr5ndks/test01.pbix?rlkey=na7webydnvk2lxtg9gk9brfxf&st=... 

https://www.dropbox.com/scl/fi/uatvtyw6k6ccekv7py6l2/test01.xlsx?rlkey=ckeh616t1q6v4pmw0gjjyv194&st=... 

I only want to show the contracts for which either the LastMutationDate of the contract or the Max(TrxOrderDate) of the transactions for that contract is more or equal to 12 months ago.
So 22 should be shown, because LastMutationDate = '01-01-2023'.
And also 66 because Max(TrxOrderDate) = '03-01-2024'

How do I get this working? And will it also work if I add another dimension to the star schema or extra columns to the table named 'Selection'?

I hope someone can help.
Thnx in advance
Ron

[lbendlin · Accepted solution]

Your pbix file has implicit measures disabled. That may be what tripped you up.

What should happen if BOTH intervals are greater than 12 months?

[PowerRon]

HI @lbendlin 

thnx for helping. Really appreciate it.
If BOTH are greater the contract should be shown as well.
So if your measure 'Check' > 0, the contract should be shown. It works.

What do you mean with implicit measures disabled? I am not aware I disabled it. Always use by the way explicit measures.

Regards
Ron

[danextian]

You might have created a calculation group which automatically disables implicit measures which doesn't get undone even after deleting the group.