Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Can't create a measure using one column...

I create a table using Enter Data (at Power Query Editor). Only has 2 columns: progress1, target1.   But I can't create a measure using one column. Why?    
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi, Try the below measure. 

     

    Measure = FORMAT(CALCULATE(MAX(Table[progress1])),"percent")

     

    The one you are trying will work for the calculated column.