Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |