Can we use column headers in DAX formulas?

[treesafranco]

We have an option to use the column header in formulas in Excel. Does Power BI has similar option?

Something like this

[Anonymous]

Hi @treesafranco,

Current, dax not support to get the column name, you can use power query to achieve the requirement.

Sample:

Custom=Table.ColumnNames(#"previousSteps"){0}

Reference link:

Dealing with tables with changing headers in Power Query

BTW, you can also use PreviousSteps{index} to get the specify row content in power query.

Custom=#"previousSteps"{0}

Regards,

Xiaoxin Sheng

[Greg_Deckler]

I'm not aware of a way to do that in Power BI. However, I'm not sure that your formula is working correctly, shouldn't your first two items be TRUE? In Power BI, you would create a similar formula like this:

=IF(YEAR([Acquisition Date]) = 2012,TRUE,FALSE)