cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rodneyc8063
Helper V
Helper V

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

 

test.jpg

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"

 

TEST1.jpg

 

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

 

TEST2.jpg

 

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

 

TEST3.jpg

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

1 REPLY 1
krishna0
Helper I
Helper I

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,

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors