Solved: Excel and Dax

singhrajendra12 · ‎09-28-2024

Hi Guys,

Just got in here.

Wondering when calculated colaums can be generated,why dax formulae and measures are required.

Thank you

lbendlin · ‎09-29-2024

In Excel you can do one of two things - you can either run a DAX query that returns a table (and in that table everything is a column) or you can create a data source via Power Query where you can modify the original source by adding columns.

Measures are not something you do in Excel. That's what you have your cell formulas for.

View solution in original post

singhrajendra12 · ‎09-30-2024

Thank you,

Its super useful resolution

lbendlin · ‎09-29-2024

In Excel you can do one of two things - you can either run a DAX query that returns a table (and in that table everything is a column) or you can create a data source via Power Query where you can modify the original source by adding columns.

Measures are not something you do in Excel. That's what you have your cell formulas for.