How to EXCLUDE data from the past 12 months?

[adadeacon]

I have a report where I need to show the contact details of the active and inactive users on a web site.

I've managed to use the 'last login date' field and the "Relative date" filter to show the users who had logged in during the past 12 months. These are considered active users.

Filter type: Relative date

- is in the past

- 12

- months, include today

I cannot seem to figure out how to show the users who had 'not' logged in during the past 12 months. Ie. I want to show the list of users and exclude the ones with a 'last login date' that falls within the last 12 months.

Any advice?

[adadeacon · Accepted solution]

Thanks Tom, I'm a beginner when it comes to Power BI. Any tips on how I could create the IsActiveMeasure?

[tackytechtom]

hi @adadeacon ,

In this case I'd probably create a measure like IsActiveUser that returns a 1 or true if it is one and a 0 or false if it is not. Then you can use that flag in the filter pane.

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[adadeacon · Accepted solution]

Thanks Tom, I'm a beginner when it comes to Power BI. Any tips on how I could create the IsActiveMeasure?

[tackytechtom · Accepted solution]

Hi @adadeacon ,

Maybe something like this? 🙂

Here the DAX: 

IsActiveMeasure = 
IF ( SELECTEDVALUE ( Table[Date] ) >= DATE ( YEAR (TODAY() ) -1, MONTH ( TODAY() ), DAY( TODAY() ) ), 1, 0 ) 

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/