Missing columns in function

[PetrK]

Hi,

I have table with more than 20 columns with string values, but when I want to create new measure to get length of string in some of columns

myLenght = Len(...

PBI doesn't display any columns which are in table. It offer for selection just a few measures which I created before.

Why I can't use any column from my table?

thank you

[PetrK]

thank you

[DataInsights · Accepted solution]

@PetrK,

Measures require that you use an aggregate function to reference a column. For example, you can use the MAX function followed by the column name. Alternatively, you can create a calculated column which has a row context, and thus no aggregate function is required.