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

[Anonymous]

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 · Accepted solution]

Hi, Try the below measure. 

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

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

[amitchandak]

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