Solved: Missing columns in function

Anonymous · ‎02-06-2023

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

DataInsights · ‎02-07-2023

@Anonymous,

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.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

View solution in original post

Anonymous · ‎02-08-2023

thank you

DataInsights · ‎02-07-2023

@Anonymous,

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.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!