XL ★The Complete Guide To Power Query

20210217 2242 

 

Ref

[1] "www.howtoexcel.org/power-query/the-complete-guide-to-power-query/"

 

[2] "towardsdatascience.com/power-bi-m-vs-dax-vs-measures-4c77ae270790"

[3] "stackoverflow.com/questions/39632894/whats-the-difference-between-dax-and-power-query-or-m"

[4] "www.sqlshack.com/differences-between-the-m-language-and-dax-in-power-bi/"

[5] "radacad.com/m-or-dax-that-is-the-question" ★ 

 

 

Concepts

▶ M code can be found in "Edit Queries" ⇒ Data query purpose

▶ DAX can be found in formula bar in PQE  ⇒ Data Analysis purpose

▶ Measure

▶ Calculated columns

 

see [2]~[3]