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,
I have a problem when joining my Calendar Dimensions table with the fact tables(Enquiries & Pipelines , Job Orders),
The relationships I created between calendar table and other two fact table are as below,
The problem I have is when I use my Calendar Dimensions - Date in matrix to find out the potential value from Enquiries & Pipeline table, it is just blank,
But when I use the date field(Created) from Enquiries&Pipeline table to generate the potential value, it does generates the proper values.
I have been stuck with this issue for about a day. Can anyone please help on this asap because this is delaying other things in my organisation. Many thanks people
Cheers
Solved! Go to Solution.
Hi @Barath,
A couple of thinks to check. Make sure the datatype for all the columns used in this scenario are the same. I suggest using DATE rather than DATETIME, and specify this in the Query Editor,
Then simply check that you have all the values in your calendar table that match your fact data.
Hi @Barath,
A couple of thinks to check. Make sure the datatype for all the columns used in this scenario are the same. I suggest using DATE rather than DATETIME, and specify this in the Query Editor,
Then simply check that you have all the values in your calendar table that match your fact data.
It worked. Thanks Phil:)
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |