Same formula for multiple columns

Question

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

anonymous · Answer

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

dedelman_clng · Answer

You can try unpivoting your data so that each column becomes a row, with the "column type" as a column.&nbsp;Name&nbsp; C1&nbsp;C2&nbsp; C3&nbsp;C4&nbsp;C5&nbsp;C6A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A&nbsp;&nbsp;B&nbsp;&nbsp;C&nbsp;&nbsp;D&nbsp;&nbsp;E&nbsp; F&nbsp;becomes&nbsp;Name&nbsp; ColType&nbsp;&nbsp; ValueA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; F&nbsp;&nbsp;and you can then add a calcualted column against "Value".&nbsp;Hope this helpsDavid

Forum Discussion

Same formula for multiple columns

2 Replies

Related content

Sum multiple Columns formula

If formula

Cumulative formula for multiple columns

formula

DAX Formula Help