cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vkomarag Member
Member

Same formula for multiple columns

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

2 REPLIES 2
scottsen Senior Member
Senior Member

Re: Same formula for multiple columns

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

dedelman_clng New Contributor
New Contributor

Re: Same formula for multiple columns

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