Flag data if it existed in last 6 months?

[NISH72]

Hi I have customer id in my dataset. I want to flag customer id which have appeared in report in last 6 months. I want to create calculated column for it. Any dax for these to flag the IDs. Thanks

[ibarrau · Accepted solution]

Hi. The first thing you need to validate is that the tables are related. I will asume you have a fact table and a customer dimension ( one to many ).

You can create a calculated column like this:

VAR last_date = MAXX ( RELATEDTABLE(FactTable) , FactTable[Date] )

RETURN 
IF ( 
    last_date >= EDATE( today(), -6 ) ,
    "Yes" ,
    "No" ,
)

Try it and let me know if i can help, hope this helps

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.