Same formula for multiple columns

[vkomarag]

I have a 300 columns in a file. 200 columns has a value of ratings. I need to calculate something out of it(say some formula).The same formula i need to apply to those 200 columns. Right now i see that we have to create a new measure for every corresponding column.200 measures has to be created.In case in the future,if there are 100 more similar columns got added,then i need to create 100 more measures.

Is there anyway in Power BI to have a formula once and apply it everywhere required?

Appreciate your response.

Thanks

KVB

[dedelman_clng]

You can try unpivoting your data so that each column becomes a row, with the "column type" as a column.

Name  C1 C2  C3 C4 C5 C6

A     A  B  C  D  E  F

becomes

Name  ColType   Value

A         1              A

A         2              B

A         3              C

A         4              D

A         5              E

A         6              F

and you can then add a calcualted column against "Value".

Hope this helps

David

[Anonymous]

I think it is VERY likely you should reshape your data -- using Get & Transform to unpivot your data.