Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
I have a data set where is information about email delivering and opening and I want to see how long does it take to user to open the email.
Problem is, that I do not have separate columns for deliver and open, so I cant just subtract one value from another but something like this (where I have a column "status" where are more values like delivered, opened, etc and every row has its timestamp + date & time):
I can create a matrix where I can see for every email information when was delivered and when (if) was opened and I need a third column where will be the time how much it took the user to open an email (so open minus delivered)
Is it possible?
Thank you
Lukas
Hi EVEAdmin,
thank you for reply but I am not sure if I follows. On the link you provided is not the solution to my problem or am I missing something?
I dont need to convert timestamp to standard date time (or I needed it and I used the solution from this thread you sent 🙂 )
I need a new measure where will be the difference (EG from my table the first row should be 9:49:10 etc)
Thanks
Lukas
If you convert the timestap to standard date time, then you calculate the difference between the 2 dates
Yes, but this works when I have 2 separates columns right?
One columne is "email opened" and another is "email delivered" and I create third column where I use formula "email opened" minus "email delivered", right?
problem is that my data looks like the image below
Those 3 rows belong to 1 email, first represent when the email was sent, second when was delivered and third when was opened.
I tried to use some if functions but no result, I got errors or completely wrong numbers
Thanks
Lukas
Using the formula suggested in that thread, you will add a new calculated column to your model. This new calculated column will allow you to calculate the difference between the 2 dates.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |