Reply
singhrajendra12
New Member

Excel and Dax

Hi Guys,

Just got in here.

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

Thank you

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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

2 REPLIES 2
singhrajendra12
New Member

Thank you,

Its super useful resolution

lbendlin
Super User
Super User

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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)