What is the difference between DAX and Power Query

0 votes

Hello team

Can someone explain the difference between DAX and Power Query? I do not want any formulated or functional difference. Explain the difference in terms.

Sep 24, 2020 in Power BI by Roshni
 • 10,480 points • 13,469 views

1 answer to this question.

0 votes

DAX stands for Data Analysis Expressions. DAX is the formula language used in Power Pivot and Power BI Desktop. DAX uses functions to work on data that is stored in tables.

 Power Query (M) is used to query data sources, clean, and load data. Then you use DAX to analyze the data in Power Pivot.

answered Sep 24, 2020 by Gitika
 • 65,770 points

Related Questions In Power BI

0 votes
1 answer

How to share Power BI reports to clients via app.powerbi? Also what is the difference between report and dashboard in power bi app?

There are 3 forms of Power BI- Power ...READ MORE

answered Feb 8, 2022 in Power BI by CoolCoder
 • 4,420 points • 2,628 views
0 votes
0 answers

What is the difference between Power Pivot's Data Model and Power BI’s data model, and how can they be integrated effectively?

What is the difference between Power Pivot's ...READ MORE

Dec 2 in Power BI by Evanjalin
 • 7,490 points • 33 views
0 votes
0 answers

What debugging tools or methods do you use to pinpoint and resolve DAX or Power Query coding errors?

What debugging tools or methods do you ...READ MORE

Oct 30 in Power BI by Evanjalin
 • 7,490 points • 65 views
0 votes
0 answers

What are your best practices for managing code modularity and reusability in Power Query and DAX?

What are your best practices for managing ...READ MORE

Oct 30 in Power BI by Evanjalin
 • 7,490 points • 60 views
0 votes
1 answer

DAX EARLIER() function in Power Query

Solutions in the code below. Notice that ...READ MORE

answered Oct 1, 2020 in Power BI by Gitika
 • 65,770 points • 2,952 views
0 votes
1 answer

DAX / PowerPivot query functions to spread aggregated values over time period

The solution below assumes a table called ...READ MORE

answered Oct 5, 2020 in Power BI by Gitika
 • 65,770 points • 1,349 views
0 votes
1 answer

Excel PowerPivot DAX Calculated Field

You should create a relationship between each ...READ MORE

answered Oct 5, 2020 in Power BI by Gitika
 • 65,770 points • 602 views
0 votes
1 answer

Import Excel data to power Bi service

There is a  way that is directly ...READ MORE

answered Oct 22, 2020 in Power BI by Gitika
 • 65,770 points • 825 views
0 votes
1 answer

What is the difference between PowerPivot, Power Query and Power BI?

Power Query Power Query is a self-service ETL ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
 • 65,770 points • 2,025 views
0 votes
1 answer

What is the difference Between SUM() and SUMX()

Sum function (Sum()) takes the data columns ...READ MORE

answered Oct 20, 2020 in Power BI by anonymous
 • 65,770 points • 3,188 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.