Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
giroldoale
Helper I
Helper I

Connecting two tables with dates

‎03-26-2021 03:06 AM

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:

  1. why in the report once I connect the filed "Data" (Date in Italian) the Hierarchy in the case 1 fo "Sales" is cancelled?
  2. why in the case 2 I cannot chooose the direction of relationship?
  3. why in case two if I drag Data from "Sale Unic" to "Calendar 2" the Hierarchy in Data of "Sales Unic" is cancelled? And if I do the opposite, so drag Data from  "Calendar 2" to "Sale Unic" the Hierarchy in Data of "Calendar 2" is cancelled? Even if the arrow of relationshiop is the same?

     

    giroldoale_0-1616750756461.png

     

Labels:
Message 1 of 44
2,795 Views
0
1 ACCEPTED SOLUTION
v-eqin-msft
Community Support
Community Support

‎03-31-2021 01:41 AM

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.

3.31.3.direction.PNG

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.

View solution in original post

Message 3 of 44
2,725 Views
0
43 REPLIES 43
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:28 AM

Don't @giroldoale,


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

Message 44 of 44
2,320 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:24 AM

Don't @giroldoale,


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

Message 43 of 44
2,320 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:22 AM

Don't @giroldoale,


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

Message 42 of 44
2,320 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:19 AM

Don't @giroldoale,


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

Message 41 of 44
2,320 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:16 AM

Don't @giroldoale,


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

Message 40 of 44
2,320 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:13 AM

Don't @giroldoale,


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

Message 39 of 44
2,320 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:10 AM

Don't @giroldoale,


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

Message 38 of 44
2,320 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:08 AM

Don't @giroldoale,


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

Message 37 of 44
2,320 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:05 AM

Don't @giroldoale,


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

Message 36 of 44
2,320 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:02 AM

Don't @giroldoale,


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

Message 35 of 44
2,320 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:59 AM

Don't @giroldoale,


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

Message 34 of 44
2,320 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:57 AM

Don't @giroldoale,


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

Message 33 of 44
2,320 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:54 AM

Don't @giroldoale,


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

Message 32 of 44
2,320 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:51 AM

Don't @giroldoale,


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

Message 31 of 44
2,320 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:49 AM

Don't @giroldoale,


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

Message 30 of 44
2,321 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:46 AM

Don't @giroldoale,


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

Message 29 of 44
2,321 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:44 AM

Don't @giroldoale,


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

Message 28 of 44
2,321 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:42 AM

Don't @giroldoale,


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

Message 27 of 44
2,321 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:40 AM

Don't @giroldoale,


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

Message 26 of 44
2,322 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:37 AM

Don't @giroldoale,


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

Message 25 of 44
2,322 Views
0

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

View All