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.
I have a dataset table with calculated columns and measures. I need to duplicate the same dataset. How do we do that?
When I tried, I could just copy the normal columns while calculated columns and measures are not getting duplicated
Solved! Go to Solution.
if you want to copy the whole table with calculated columns then create a calculated table and assign your table like
New Table = your table
Hope it will help
Regards
sanalytics
if it is your solution then please like and accept it as solution
Hi @pranesh246 ,
As @sanalytics said, you only need to create a calculated table: New Table = your table,the formula can copy all table data including calculated columns.
But you can not copy the measures because measures are not fields of any tables, and there is no need to have two exactly the same measure for the same .pbix file.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @pranesh246 ,
As @sanalytics said, you only need to create a calculated table: New Table = your table,the formula can copy all table data including calculated columns.
But you can not copy the measures because measures are not fields of any tables, and there is no need to have two exactly the same measure for the same .pbix file.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
if you want to copy the whole table with calculated columns then create a calculated table and assign your table like
New Table = your table
Hope it will help
Regards
sanalytics
if it is your solution then please like and accept it as solution
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 |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |