Forum Discussion
Alessandro-laba
Helper I
Helper IFirst date fro groups of emails
Hi there, I am trying to develop a dahsboard to report on our Marketing effectiviness. As part of this porject I want to show the best day to email our contacts to improve our email open rate. T...
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".
Alessandro-labaHelper I
Helper IHi 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
Community Champion
Community ChampionRight, 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
- Greg_Deckler
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".