Forum Discussion
Helper IFirst date fro groups of emails
That is incredibly too little information to go on. "Doesn't work". It works for me, see attached PBIX.
I will need an explantion of "Doesn't work".
Community ChampionWell, one comment is that I think your use of CALCULATE is meaningless in that formula since you do not supply a filter clause. Second, try using MINX to get your date. With all that said, sample data and expected output are always extremely helpful. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Alessandro-labaHi Greg,
These are the data:
Email sent:
Email Open:
This is the day filter I have in my dashboard:
So for Email A when I click on Tuesday I want to see the date value while when I click on Wednsday I don't wanna see any value for Email A since the first opened happened on the day before.
Thanks,
Ale
- Greg_Deckler
Right, so in your Email Open table, create a calculated column like this:
First Open = WEEKDAY( MINX( FILTER( ALL('Email Open'), [Email name] = EARLIER([Email name]) && [ContactID] = EARLIER([ContactID]) ), [Emai Open] ) )Then just tie your slicer to that column.
- Alessandro-laba