Forum Discussion
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!
Anonymous , first un pivot this data
https://radacad.com/pivot-and-unpivot-with-power-bi
and try measure
if(isblank(countrows(filter(Table, Table[Action] in {"Opened","Clicked"}))),1,blank())
1 Reply
- amitchandakSuper User
Anonymous , first un pivot this data
https://radacad.com/pivot-and-unpivot-with-power-bi
and try measure
if(isblank(countrows(filter(Table, Table[Action] in {"Opened","Clicked"}))),1,blank())