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.

     

     

     

2 Replies

  • Take the column name from auto-suggest. there might be space at the end or beginning. Or rename it try

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, Try the below measure. 

     

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

     

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