cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerBIAccount
New Member

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!

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@PowerBIAccount , 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())



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

1 REPLY 1
amitchandak
Super User IV
Super User IV

@PowerBIAccount , 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())



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors