The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have some doubts with relationship through dates.
My aim is to have a single table called "Calendar" where I connect all the DataTable with dates, so use only the date into "Calendar" to works with time across the report.
I have 2 cases in the screenshot, both the table "Calendar" and "Calendar 2" have the same data set.
"Calendar", and so "Calendar 2", is a LUT table having only the function to generate a calendar from 2018 to date. In this sense in these two table there are no repeting dates.
In "Sales" there are dates from Jan/21 to date and for every day the corresponfding value of Qty and Value sold. Every dates is unique except to 08/01/2021 (DD/MM/YYY) that is repeated 2 times.
In "Sales 2" there are dates from Jan/21 to date and for every day the corresponfding value of Qty and Value sold. Every dates is unique.
Recaping the only difference between the two cases in term of data is a single row into Sales that is repeted 1 time.
Now the questions:
Solved! Go to Solution.
Hi @giroldoale ,
For the second question, to my knowledge, the relationship is always from 1 to many. In the case of 1: 1, it could not identify which is "many".Therefore, 1:1 can only be a one-way direction.
For the third question,it is intended behaviour, in this case you will use date field from date table to work in your visuals.Refer to :Solved: Re: Date hierarchy missing - Microsoft Power BI Community
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.
Best regards
Qin eyelids
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
247 | |
122 | |
110 | |
77 | |
72 |