Forum Discussion

CCTADA's avatar
CCTADA
Frequent Visitor
4 years ago

SUM rows with IF clause return number

New user and I thought I was doing good until my data was summed and it wasn't even close. Darnit! 🙂 Yes, I searched but I didn't find what I needed.   Column E is where I'd like to create a colum...
Need Help
CCTADA's avatar
CCTADA
Frequent Visitor
4 years ago

Anonymous AllisonKennedy 

I'm working on adding these both ways. What is the difference between using Power Query and creating a column vs adding a Measure? If there's an article, let me know - noob here so I'm still trying to get through a lot of this basic material while I create things.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  CCTADA ,

 

M and DAX are two completely different languages.

 

M is used in Power Query (a.k.a. Get & Transform in Excel 2016) and the query tool for Power BI Desktop. Its functions and syntax are very different from Excel worksheet functions. M is a mashup query language used to query a multitude of data sources. It contains commands to transform data and can return the results of the query and transformations to either an Excel table or the Excel or Power BI data model.

 

More information about M can be found here and using your favourite search engine.

 

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. Some DAX functions are identical to Excel worksheet functions, but DAX has many more functions to summarize, slice and dice complex data scenarios.

 

There are many tutorials and learning resources for DAX if you know how to use a search engine. Or start here.

 

In essence: First you use Power Query (M) to query data sources, clean and load data. Then you use DAX to analyze the data in Power Pivot. Finally, you build pivot tables (Excel) or data visualisations with Power BI.

Differences between the M Language and DAX in Power BI.

 

And measure vs calculated column: What is the difference between Power BI calculated columns and measures? - TrueCue.

 

Reference: powerbi - What's the difference between DAX and Power Query (or M)? - Stack Overflow

                  

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.