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 two table 1 is project and it contains projectkey column and the 2 table is getissues and that has projectkey column.i dont know which join condition is used.But in get issues table 5 columns is their i want that 5 columns and project table conatins 4 columns and i want that 4 columns.how to create a query in Power Bi (or) is their any dax forumuls.can you provide me ASAP or any links
Regards
jayendra
Solved! Go to Solution.
@jayendra wrote:
HI
I have two table 1 is project and it contains projectkey column and the 2 table is getissues and that has projectkey column.i dont know which join condition is used.But in get issues table 5 columns is their i want that 5 columns and project table conatins 4 columns and i want that 4 columns.how to create a query in Power Bi (or) is their any dax forumuls.can you provide me ASAP or any links
Regards
jayendra
You can just create a proper one:many relationship for those two tables. Then just drag columns from those two tables to visuals, the data would be linked automatically. For tables in relationship, you could also reference function RELATEDTABLE and RELATED
@jayendra wrote:
HI
I have two table 1 is project and it contains projectkey column and the 2 table is getissues and that has projectkey column.i dont know which join condition is used.But in get issues table 5 columns is their i want that 5 columns and project table conatins 4 columns and i want that 4 columns.how to create a query in Power Bi (or) is their any dax forumuls.can you provide me ASAP or any links
Regards
jayendra
You can just create a proper one:many relationship for those two tables. Then just drag columns from those two tables to visuals, the data would be linked automatically. For tables in relationship, you could also reference function RELATEDTABLE and RELATED
Hi @jayendra
Try the LOOKUPVALUE() DAX formula.
You go to the table, where you want all your data, and you look up the values, you need, in order to perform your calculations.
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |