Skip to main content

Power BI

New

Duplicate Calculated Columns/Measures

Vote (17) Share
Mitchell's profile image

Mitchell on 07 Mar 2018 00:13:42

I have a lot of calculated fields that are set up the same but with different constants. It would be nice to be able to duplicate a field (similar to duplicating a page) and then edit duplicated field. It would increase the efficiency vs. copying calculation, creating new column, pasting calculation, changing the formatting and properties.

Comments (3)
Mitchell's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:17:28

RE: Duplicate Calculated Columns/Measures

This would save quite some time. Best would be also if you could select multiple fields and duplicate it

Mitchell's profile image Profile Picture

ce16f4e3 09de-4eac-9e37-4604ec663bb0 on 06 Jul 2020 00:15:35

RE: Duplicate Calculated Columns/Measures

Totally agree with this idea!
Or for example, be able to export existing calculation (in excel for example) > in Excel, copy paste calculation and adapt them > then reimport them in PBI

Mitchell's profile image Profile Picture

a9c38bb7 decf-49b7-a693-4826b0645c9c on 05 Jul 2020 23:33:18

RE: Duplicate Calculated Columns/Measures

I also need this featureĀ” When I do measures MTD , YTD, LY YTD, PY, etc. whit different constants and diferentt currencies