Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Compare STRING Values over X Time

Hello Everyone,

 

Sorry, I am kind of new to POWER BI and have a challenge where I failed so far finding a solution.

Basically I need to compare String values, in order to see if the users have touched their mails or not over the past x years.

 

I assume I’ll have to work with a measure, but both ROW and FILTER weren’t that helpful so far.

 

My data looks like:

 

Year

User12345

User987465

User54451

2017

Sent

Bounced

Clicked

2018

Opened

Sent

Clicked

2019

Clicked

Sent

Sent

2020

Sent

Sent

Sent

 

 

Has anyone another approach on how to filter all the users who never had “Opened” or “Clicked” in the past x years?

 

Sorry, if this is the incorrect place for this question. Perhaps I am overthinking this as well, and the solution is very easy.

 

Thanks for your help!