Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to 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
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
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)?
Proud to be a Super User!
User | Count |
---|---|
98 | |
91 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |