Forum Discussion

rodneyc8063_1's avatar
rodneyc8063_1
Helper V
5 years ago

Intellisense Not Showing Table Column in Measure Formula?

So I am new to Power BI and am still learning the language.

 

Early on, I sort of just "trusted" Intellisense and didnt question it very much on how it worked but I just came across something and just wanted to finally ask my silly question 🙂

 

Using a very simple example, I have a table with one single column and row inside of it

 

Now, I am just playing around and trying to use the FORMAT function.

 

I create a calculated column by right clicking on the table and selecting "New Column"

 

 

I start to type out my formula [ Column = FORMAT(DATE..... ] and intellisense picks up the table/table column as shown

 

 

Now when I repeat the same steps but this time create "New Measure" intellisense does NOT pick up the table or column?

 

I know Intellisense is supposed to be "smart" enough to know when to suggest certain things, so it makes our lives easier coding. But I was just curious in this case, I am typing out the exact same basic formula with the only difference being that one is in a calculated column, and another is in a measure.

 

So why would Intellisense not let me choose the table/column in a measure?

 

I have noticed also in the past that at times when typing certain formulas that intellisense would "sometimes" show columns, and "sometimes" it would not.

 

I just wanted to understand a bit more "why" intellisense would show or not show columns when typing a formula? 

 

Thanks in advance for any help or insight

Need Help

1 Reply

  • krishna0's avatar
    krishna0
    Helper II
    5 years ago

    Hello,

     

    Format requires single value as an input - you will be not able to use column. It will work only on aggregated value (for example on effect of Calculation formula). If you try to type: format(max([Date)), then it will work.

     

    It works on column because in the column you receive one value per each row, but not in a measure - this takes whole table/column as an input (until you aggregate) and that is one of the basic differences between column and measure formulas.

     

    Best regards,