- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Difference between Measure, Power Query, and R Script
Hello PBI Community,
I am having a blast in diving into PBI and creating my first project.
I working with a complicated multi-level & -parents data table that requires me to filter up and down the relationship.
I am hoping to understand when to use measure, power query, and R script to approach the work sensibly.
In short, what are some key differences and what are the right applications for each?
- Power Query
- Measure
- R Script
Thank you!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi, @tk0501
PowerQuery(M) mainly used for data transformation
Measure(DAX) provides a specialized syntax for querying Analysis Services tabular model.
R Script is a procedural programming language
Here are some articles for you refer to:
https://radacad.com/m-or-dax-that-is-the-question
https://bigdata-madesimple.com/r-may-better-option-m-power-bi/
https://powerpivotpro.com/2017/08/power-bi-dax-m-vs-r-summer-perspective/
Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.
Best Regards,
Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi, @tk0501
PowerQuery(M) mainly used for data transformation
Measure(DAX) provides a specialized syntax for querying Analysis Services tabular model.
R Script is a procedural programming language
Here are some articles for you refer to:
https://radacad.com/m-or-dax-that-is-the-question
https://bigdata-madesimple.com/r-may-better-option-m-power-bi/
https://powerpivotpro.com/2017/08/power-bi-dax-m-vs-r-summer-perspective/
Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.
Best Regards,
Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you Lin @v-lili6-msft
Could you recommend articles on measure vs calculated columns?
What other basic fundamental topics should I understand in order to become a good PBI user?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi, @tk0501
Could you please tell me if you have other problem? If not, could you please mark the helpful replies as Answered.
Best Regards,
Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi, @tk0501
For power bi, The best documents are:
https://docs.microsoft.com/en-us/power-bi/power-bi-creator-landing
I also learned through this document.
For measure vs calculated columns,
1. Calculation column/table not support dynamic changed based on filter or slicer.
2. measure can be affected by filter/slicer, so you can use it to get dynamic summary result.
here is reference:
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Best Regards,
Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
11-24-2023 01:55 PM | |||
04-14-2024 04:35 PM | |||
06-18-2024 06:13 AM | |||
06-20-2023 01:28 PM | |||
11-20-2023 05:13 AM |
User | Count |
---|---|
141 | |
117 | |
80 | |
65 | |
47 |