The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi everybody !
I just need to copy a column from a table to another and my value are source of date like I show you in the following picture :
I try related or Summarize but nothing worked...
I want the column of my first table on my second table ..
Best regards
Davidb023
Solved! Go to Solution.
it seems you are creating measure. Creat new column then only column suggestions would appear in your syntax.
see screenshot of measure where suggestion didn't appear.
and when i created column then suggestion appeared
I success to create new column with data from other table, I have created a relation between the two tables (with date column) and after that column from the other table appear in RELATED(). Thanks !
Best regards
DavidB023
This can be achieved using related. First of all check whether date field is date type or not. If it is date type then create a new custom column=related(column which you want) and done. now create a table visual using your previous fields along with this newly created column. Make sure you have checked "show items with no data" if you want to show the same. see screenshot attached
I already try to use function Related(column) but I can't choose a column from an another table, just column which are on the first table..
it seems you are creating measure. Creat new column then only column suggestions would appear in your syntax.
see screenshot of measure where suggestion didn't appear.
and when i created column then suggestion appeared
I success to create new column with data from other table, I have created a relation between the two tables (with date column) and after that column from the other table appear in RELATED(). Thanks !
Best regards
DavidB023
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 August 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
78 | |
66 | |
52 | |
51 |
User | Count |
---|---|
127 | |
116 | |
78 | |
64 | |
63 |