Flag members based on date

[NISH72]

Hi everyone I have a members and date column in a report which is connected to SQL database and I want to flag members who have appeared in report more than 6 months ago. The report has been refreshing daily since last 1 year. What would be the dax to flag the members. For eg today is November 26 so I want to flag members who were there in report before May 26. Thank you

[v-shex-msft · Accepted solution]

HI @NISH72 ,

I'm not so clear for your data structure, can you please share some sample data for test? 

How to Get Your Question Answered Quickly  

In addition, you can also try to use below formula if it suitable for your requirement:

Flag =
IF (
    COUNTROWS (
        FILTER (
            'Table',
            [UserID] = EARLIER ( 'Test'[UserID] )
                && [ReportDate]
                    < DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 6, DAY ( TODAY () ) )
        )
    ) >= 1,
    "Y",
    "N"
)

Regards,

Xiaoxin Sheng

[NISH72]

Can someone please help.

[Anonymous]

Add this measure in the table:

new measure = CALCULATE(COUNT('table'[Name]), FILTER('table','table'[Date] < [(Today() - 180)] ))

It counts how many times one name is appeared in the list , which date is before 180 days ago.

[JarroVGIT]

Do you want to flag members that are in the report today and more than 6 months ago? The way you are framing your question now is that you just want to display members which appeared more than 6 months ago (which is a simple visual filter or page filter)?