Forum Discussion
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 j...
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,