Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Import a column from another table

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 :)
Need Help

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    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