Forum Discussion
harib
Post Patron
Post PatronHOW TO CONVERT COLUMN TO MEASURE
Hello Friends
I have a column(Ratio) in table. I would like to convert that column into measure without changing the values .
Ex :
Ratio
0.6
0.65
0.7
0.75
Is there any formula to convert column into measure. Can anyone help in this
Thanks in advance
Hi harib
You may create an index column for it.Then create measure like below to show them in matrix.
Reference:https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Measure = SUM(Table1[Ratio])
Regards,
1 Reply
v-cherch-msftMicrosoft Employee
Hi harib
You may create an index column for it.Then create measure like below to show them in matrix.
Reference:https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Measure = SUM(Table1[Ratio])
Regards,