in Education by
I have been working on Power BI for a while now and I often get confused when I browse through help topics of it. They often refer to the functions and formulas being used as DAX functions or Power Query, but I am unable to tell the difference between these two. Please guide me. Select the correct answer from above options

1 Answer

0 votes
by
 
Best answer
M and DAX are expression languages in Power BI. Both of them are similar to MS Excel expressions, as both of them are different from each other and are used differently for building Power BI models. M can be viewed in Power Query Editor which is a query language. When transformations are done, expressions are automatically generated in M.To see the M expressions, enable formula bar on the view button. Data Analysis Expressions(DAX) is a language used for creating transformations in Power BI Desktop main screen. It uses various functions to work on data that is stored in tables To refer to functions in DAX, refer to this https://docs.microsoft.com/en-us/dax/dax-function-reference To refer to functions in Power Query M, refer to this https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

Related questions

0 votes
    What is the difference between PowerPivot, PowerQuery and PowerBI? How should one decided which tool should be used and when. Select the correct answer from above options...
asked Feb 4, 2022 in Education by JackTerrance
0 votes
    In Power Query, when I right-click on the name of a query (in the left-most pane of Power Query's ... appreciate a brief tutorial. Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    In Power Query, when I right-click on the name of a query (in the left-most pane of Power Query's ... appreciate a brief tutorial. Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    Does anyone know of a way in Power BI to set query parameters as described here from an embed request ... for the visualization. Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    Does anyone know an implementation case that involves PowerBI and ElasticSearch? I was unable to find any proper documentation. Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I have an ASP.Net core 1.1 website and I want to embed Power BI reports into the site. Azure ... JsonConvert.DeserializeObject(result); Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I have written an SQL script which runs fine when executed directly in SQL Management Studio. However, when entering ... are removed: Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I am trying to use Microsoft Power Bi to connect to a PostgreSQL database. When I go to Get Data it just ... driving me crazy! Thanks Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I am trying to use Microsoft Power Bi to connect to a PostgreSQL database. When I go to Get Data it just ... driving me crazy! Thanks Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    I want to parse a .json column through Power BI. I have imported the data directly from the server and ... simplified parsed columns. Select the correct answer from above options...
asked Feb 4, 2022 in Education by JackTerrance
0 votes
    I'm trying to use the Power BI REST API, using an access token acquired with the "client credentials" method, ... What am I missing? Select the correct answer from above options...
asked Feb 4, 2022 in Education by JackTerrance
0 votes
    In my application, I'm displaying a Power BI report. It already works, so there's no problem with showing ... dataset in the report? Select the correct answer from above options...
asked Feb 4, 2022 in Education by JackTerrance
0 votes
    I find it difficult to wrap my head around developing a PowerBI visual from scratch. I was reading wiki, guide, ... thanks in advance. Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I have an IFrame which shows a PowerBI embedded Report that having a world map. Can I pass a parameter to ... specific country. Thanks Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    What's the difference between SDK and Runtime in .NET Core?...
asked Feb 16, 2023 in Technology by JackTerrance
...