cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tez
Resolver I
Resolver I

Calculations in Dataflow or Dataset (Power Query or DAX)?

How can I decide whether to create calculations (e.g. calculated columns) in a dataflow (Power Query) or later in a dataset (DAX)? I've read several web pages about the dataflow/dataset topic, but I'm still not sure how to split the calculations. Is it just a matter of taste, or are there significant advantages and disadvantages for both variants?

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@tez 

It is always better to keep the column at the source level, then think of PQ, failing that DAX.

Refer to: https://www.sqlbi.com/articles/comparing-dax-calculated-columns-with-power-query-computed-columns/
https://www.youtube.com/watch?reload=9&v=ZSUCmi6h5SY

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

2 REPLIES 2
Eyelyn9
Community Support
Community Support

Hi @tez ,

 

Custom columns are created using the PowerQuery M Langauge and Calculated columns are created using DAX Expressions and are part of the data model.

 

In addition to the difference of language, you could take a look at the official document for further information.

 

As @Fowmy  said, we usually prefer to create a custom column in Power Query for lower memory.

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

 

Best Regards,

Eyelyn Qin

Fowmy
Super User
Super User

@tez 

It is always better to keep the column at the source level, then think of PQ, failing that DAX.

Refer to: https://www.sqlbi.com/articles/comparing-dax-calculated-columns-with-power-query-computed-columns/
https://www.youtube.com/watch?reload=9&v=ZSUCmi6h5SY

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors