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,
The requirement is, i have 3 tables with 3 different columns and now i have to use those 3 columns in a new measure
i am unable to merge those 3 columns getting data as null and merging is not happening
Table 1 - FinancialKPI
Table 2 - Project custom
Table 3 - Gate
Now i need to bring 2 columns from Project custom[Approved Gate], Gate[Value] to FinancialKPI table? Any suggestion please
final output i have to achieve by merging 3 tables but not able to merge those columns due to not matching columns
- CALCULATE(SUM(FinancialKPI[Y1]),FILTER(FinancialKPI,FinancialKPI[KPIName]=
"Net Sales [Project Currency]" && FinancialKPI[Approved Gate] = FinancialKPI[value]))
Thanks
Solved! Go to Solution.
Hi @Baburao2123490 ,
If you do not matcing columns and want to combine columns, try adding an index column to each table in Power Query as shown below:
Then you can merge by index column:
At last, you can merge 3 tables 3 columns:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Baburao2123490 ,
If you do not matcing columns and want to combine columns, try adding an index column to each table in Power Query as shown below:
Then you can merge by index column:
At last, you can merge 3 tables 3 columns:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Can any help me Please.
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |