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 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.
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 |
---|---|
95 | |
94 | |
80 | |
71 | |
64 |
User | Count |
---|---|
115 | |
106 | |
96 | |
81 | |
72 |