Forum Discussion
Two tables linked by date
Hi,trogne
Thanks for the quick reply.
Yes, you are right, "time" is a calculation table.
Secondly, regarding the issue that your calculation table cannot lock the relevant columns, you must have noticed from the pbix file we shared earlier that the calculation table is working fine in our file, so we speculate that this may be a version issue, so we recommend that you try to download the latest version.
Here is the official download link for the latest version:
Download Microsoft Power BI Desktop from Official Microsoft Download Center
Secondly, you can also try the following two calculation tables in your version, I hope it will help you:
time = VAR time1=SELECTCOLUMNS('Forge','Forge'[Date]) VAR time2=SELECTCOLUMNS('Local1234','Local1234'[Date]) RETURN UNION(time1,time2)time = VAR time1=SELECTCOLUMNS('Forge',"1",'Forge'[Date]) VAR time2=SELECTCOLUMNS('Local1234',"2",'Local1234'[Date]) RETURN UNION(time1,time2)
You may need to note that if you re-calculate the following two columns, the names of the columns generated by it may change, and you will need to reconfigure the table relationships.Here are the relevant links:
SELECTCOLUMNS function (DAX) - DAX | Microsoft Learn
UNION function (DAX) - DAX | Microsoft Learn
If you have any new discoveries, please feel free to contact us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,trogne
Thanks for the quick reply.
Yes, you are right, "time" is a calculation table.
Secondly, regarding the issue that your calculation table cannot lock the relevant columns, you must have noticed from the pbix file we shared earlier that the calculation table is working fine in our file, so we speculate that this may be a version issue, so we recommend that you try to download the latest version.
Here is the official download link for the latest version:
Download Microsoft Power BI Desktop from Official Microsoft Download Center
Secondly, you can also try the following two calculation tables in your version, I hope it will help you:
time =
VAR time1=SELECTCOLUMNS('Forge','Forge'[Date])
VAR time2=SELECTCOLUMNS('Local1234','Local1234'[Date])
RETURN UNION(time1,time2)time =
VAR time1=SELECTCOLUMNS('Forge',"1",'Forge'[Date])
VAR time2=SELECTCOLUMNS('Local1234',"2",'Local1234'[Date])
RETURN UNION(time1,time2)
You may need to note that if you re-calculate the following two columns, the names of the columns generated by it may change, and you will need to reconfigure the table relationships.
Here are the relevant links:
SELECTCOLUMNS function (DAX) - DAX | Microsoft Learn
UNION function (DAX) - DAX | Microsoft Learn
If you have any new discoveries, please feel free to contact us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think it was not working because "forge_visiteurs" and "frequentation_TEST" are not "tables". They are "queries" (to the right).
But I have no errors with your second method!
On the right, the name of the data is "dateforge". Since it's an union, I would have expected something else.
Then I did the relationship, and it all works fine ! Thank you!
What happened to my 2 original "Date" fields ?
They are no longer normal dates (with date hierarchy and so on).
Patrick
Hi,trogne
Thanks for the quick reply.
After a table relationship is established, it is normal for the automatic time and date of the table to disappear, and the specific automatic date and date of the table are also related to the type of table relationship and the order in which the relationship was established. Here are my actual results:
1.In the case of one-to-one and many-to-many relationships, the next one retains the automatic time and date:
2.In the case of a one-to-many relationship, the table in one location retains the automatic date and date:
3.Here are links to similar issues to you:
Solved: Date Hierarchy Disappears when Connected to Anothe... - Microsoft Fabric Community
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your help!