Skip to main content

Power BI

Needs Votes

Duplicate Measure and Format Copy

Vote (912) Share
Giampaolo Pitzalis's profile image

Giampaolo Pitzalis on 30 Mar 2016 22:07:51

It would nice to have the option to duplicate an existing measure (include formatting) and copy/paste the format of a measure (like Format Painter).

Comments (85)
Giampaolo Pitzalis's profile image Profile Picture

d529876a a3cb-41e2-9a03-18af86fea750 on 05 Jul 2020 23:59:20

RE: Duplicate Measure and Format Copy

Any update ???

Giampaolo Pitzalis's profile image Profile Picture

f038a3e1 5541-430e-9f7e-f1445c61b06b on 05 Jul 2020 23:59:10

RE: Duplicate Measure and Format Copy

Yes , That would be fantastic

Giampaolo Pitzalis's profile image Profile Picture

033d5ff4 953b-4c63-8eea-74111823b60f on 05 Jul 2020 23:56:18

RE: Duplicate Measure and Format Copy

An example for me where this is helpful. I have a master table with 20 measures that aggregates 30 different tables. I then filter which table sources to display based on the user view (i.e. One director only wants to see the 20 measures calculated from 7 of the 30 tables, while another one wants to see 10 of the 30 tables, etc.). However, my performance is taking a major hit. To address this I now need to create a separate master table for each director, instead of one master table, and replicate the 20 measures for each director, which will be a huge pain, but I need to do it as it reduces my load time from 90 seconds to 12 seconds.

Giampaolo Pitzalis's profile image Profile Picture

eda4b701 ebb9-4401-8ca3-ff331027da10 on 05 Jul 2020 23:55:44

RE: Duplicate Measure and Format Copy

Yes. This definitely needs to exist.

Giampaolo Pitzalis's profile image Profile Picture

f07917af af89-4a33-95bb-f248c95f5ce1 on 05 Jul 2020 23:55:43

RE: Duplicate Measure and Format Copy

very important to me!!

Giampaolo Pitzalis's profile image Profile Picture

935ce132 d08b-4390-ad75-018bfacd1b02 on 05 Jul 2020 23:55:39

RE: Duplicate Measure and Format Copy

Yes, needed

Giampaolo Pitzalis's profile image Profile Picture

8906d01b bc9e-400a-8f87-bbf4724d9f3a on 05 Jul 2020 23:55:11

RE: Duplicate Measure and Format Copy

Agree. I need to replicate many DAX measures from one data set to another. is this possible in the meantime?

Giampaolo Pitzalis's profile image Profile Picture

cf46bd46 36be-454d-a5a0-e63f8e308e74 on 05 Jul 2020 23:54:26

RE: Duplicate Measure and Format Copy

Please make this possible for us to save a lot of time

Giampaolo Pitzalis's profile image Profile Picture

50f4b78c 57f2-43f8-a0e3-b0bf796fbef3 on 05 Jul 2020 23:54:18

RE: Duplicate Measure and Format Copy

Simply being able to export and import custom measure and columns from a PBIX so you can copy them across PBIX files would be a win. Yes to this!

Giampaolo Pitzalis's profile image Profile Picture

3eab5d17 ae37-4b5d-8431-ee105be95d28 on 05 Jul 2020 23:53:30

RE: Duplicate Measure and Format Copy

Oh yes it would be great to have this ability