Import a column from another table

[Anonymous]

Hello Everyone, 

I am new to Power BI and I am blocked. I created a table and i am trying to import a column from another table but I am totally blocked. I created the table VilleEventstest (as you can see on the picture) and I would like to add the column ROI Final to the table VilleEventstest. 

Here is the DAX formula:

VillesEventsTEST = 
UNION(
    DISTINCT(
        GENERATE (
            SUMMARIZE(Recap;Recap[id]);
            CALCULATETABLE (
                SELECTCOLUMNS (
                    Recap;
                    "Ville";Recap[Ville1clean DAX]
                );
                Recap[Ville1clean DAX] <> BLANK()
            )
        )
    );
    DISTINCT(
        GENERATE (
            SUMMARIZE(Recap;Recap[id]);
            CALCULATETABLE (
                SELECTCOLUMNS (
                    Recap;
                    "Ville";Recap[Ville2clean DAX]
                );
                Recap[Ville2clean DAX] <> BLANK()
            )
        )
    );
    DISTINCT(
        GENERATE (
            SUMMARIZE(Recap;Recap[id]);
            CALCULATETABLE (
                SELECTCOLUMNS (
                    Recap;
                    "Ville";Recap[Ville3 DAX]
                );
                Recap[Ville3 DAX] <> BLANK()
            )
        )
    )
)

Thank you very Much 🙂

[v-cherch-msft]

Hi @Anonymous 

It's hard to provide an accurate solution without sample data and expected output.Please refer to this article How to Get Your Question Answered Quickly.You can upload the .pbix sample file to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,

Cherie