cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kintera
Frequent Visitor

what's the difference... column in query editor vs Data vs Report

I don't understand what the difference between columns created in these 3 places.  thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: what's the difference... column in query editor vs Data vs Report

Hi @kintera ,

 

Calculated columns are used when you want to use a calculation in another calculation or in any other visulaization(s). In other words, that costs more memory than custom column.  You can refer to this blog.

https://www.fourmoo.com/2017/02/07/power-bi-why-creating-columns-in-the-query-editor-is-better-quick...

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

4 REPLIES 4
Community Support
Community Support

Re: what's the difference... column in query editor vs Data vs Report

Hi @kintera ,

 

In Data, we can create calculated columns based on DAX. However, we cannot see these columns in Power query.
In Power query. Any custom columns that we create are based on M code. You can check the M code in Advanced editor. And you can use and see all of these custom columns in data view / report.
 
Please refer to this article to understand how Power Query(Query Editor) and Power Pivot(Data View) work together.
 
Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
kintera
Frequent Visitor

Re: what's the difference... column in query editor vs Data vs Report

Thanks for taking the time, Frank.

 

So, if I didn't want to use M code (or the wysiwyg Conditional, Column_From_Examples, etc) and was familiar with DAX, I would use the Data side. But are there any other considerations? Performance being one of them? The reference you provided was Excel-based, and didn't have much PowerBI specifics.

 

Again, thank you

Community Support
Community Support

Re: what's the difference... column in query editor vs Data vs Report

Hi @kintera ,

 

Calculated columns are used when you want to use a calculation in another calculation or in any other visulaization(s). In other words, that costs more memory than custom column.  You can refer to this blog.

https://www.fourmoo.com/2017/02/07/power-bi-why-creating-columns-in-the-query-editor-is-better-quick...

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

kintera
Frequent Visitor

Re: what's the difference... column in query editor vs Data vs Report

Thank you

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors