Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
All the tables below come from database and they're directquery.
I want to create some analysis between the tables Calendar and Subscriber, but it's not worrking.
As you can see below, they're not connected directly. What should I do?
Thanks very much!
Solved! Go to Solution.
You need to create and inactive relationship between the Calendar date and the Subscribe activation date
Or if you prefey not to have the relationship. Try
Subrscibers =
CALCULATE (
DISTINCTCOUNT ( Subribers[Cust ID] ),
TREATAS ( VALUES(Calendar[Date]), Subscribers[Activation Date] )
)
Proud to be a Super User!
Paul on Linkedin.
Is the inactive relationship between the Calendar date and the activation date? Are both fields set to type Date?
Proud to be a Super User!
Paul on Linkedin.
Hey @PaulDBrown thanks for your reply.
No relationship between Calendar and Subscribers table, and the Date and Activation Date are both set to date type.
You need to create and inactive relationship between the Calendar date and the Subscribe activation date
Or if you prefey not to have the relationship. Try
Subrscibers =
CALCULATE (
DISTINCTCOUNT ( Subribers[Cust ID] ),
TREATAS ( VALUES(Calendar[Date]), Subscribers[Activation Date] )
)
Proud to be a Super User!
Paul on Linkedin.
Thanks a million @PaulDBrown
It works and I was able to create similar measures using other fields.
Create an inactive relationship between the Calendar Table and the Subscriber table via the corresponding date fields and use this measure:
ubrscibers =
CALCULATE (
DISTINCTCOUNT ( Subribers[Cust ID] ),
USERELATIONSHIP ( Calendar[Date], Subscribers[Activation Date] )
)
Proud to be a Super User!
Paul on Linkedin.
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |