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,
I have this issue that I have columns coming from a data source. What I would like to do is to duplicate the column from another column and stop the old column overwriting the new one. So that this column would be a comparison column stored. What would be the easiest way?
Solved! Go to Solution.
The refresh is 'table' level in Power BI Desktop. If you duplicate the column, it will still exist in the same table. So once you click refresh, both of these two columns will be refreshed.
Another way is to duplicate the table in Query Editor, and right click the duplicated table and unselect 'include in report refresh' as below. Then close and apply Query Editor.
Manage relationship like below, and drag these three column into the table visual, so that you can compare the two columns.
Best Regards,
Herbert
The refresh is 'table' level in Power BI Desktop. If you duplicate the column, it will still exist in the same table. So once you click refresh, both of these two columns will be refreshed.
Another way is to duplicate the table in Query Editor, and right click the duplicated table and unselect 'include in report refresh' as below. Then close and apply Query Editor.
Manage relationship like below, and drag these three column into the table visual, so that you can compare the two columns.
Best Regards,
Herbert
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |