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.
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 🙂
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
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 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |