topic Count open ticket in first 7 days after the user signs up in DAX Commands and Tips

Count open ticket in first 7 days after the user signs up

frg88 — Thu, 17 Jun 2021 20:25:31 GMT

Hi,

I have the next 3 tables in my Power BI file:

Customer table

CustomerId	Country
1	US
2	IR
3	US

Cases table

CustomerId	CreatedDate	Subject
1	2021-01-01	Error 1
2	2021-02-02	Error 2
1	2021-01-04	Error 3

Sign up table

CustomerId	SignUp
1	2021-01-01
2	2021-02-01
3	2021-03-01

What I want is a visual where we can view the number of tickets that an user has created in the first 7 days or 1 month after it sign up. It would be like:

CustomerId	First 7 days	First 1 month
1	1	2
2	1	1
3	0	0

Can you help me with this? I've tried it with a calculated column in the "Sign up table", but I have not reach what I want.

Thanks!

Fran

Re: Count open ticket in first 7 days after the user signs up

CNENFRNL — Thu, 17 Jun 2021 21:32:34 GMT

Re: Count open ticket in first 7 days after the user signs up

frg88 — Thu, 17 Jun 2021 22:19:59 GMT

Thanks CNENFRNL!!

I've tried the solution that you have propposed me but now I obtain this error:

It seems that the duplicate values (I don't know if the column createdData of Cases table or the SignUp column) don't let me show the visual.

Thanks!

Fran