Forum Discussion
Anonymous
6 years agoNot applicable
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?
- Anonymous6 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
- amitchandak
Super User
Take the column name from auto-suggest. there might be space at the end or beginning. Or rename it try
- AnonymousNot applicable
Hi, Try the below measure.
Measure = FORMAT(CALCULATE(MAX(Table[progress1])),"percent")
The one you are trying will work for the calculated column.