Which language is used in Power BI for queries?
GeneralClass 12AllAnswered 27 Mar 2026
Answer
Power BI primarily uses two query languages: M language (also called Power Query Formula Language) for data transformation and ETL operations, and DAX (Data Analysis Expressions) for creating calculated columns, measures, and tables. M language works behind the scenes when you use Power Query to clean and shape data. DAX is used for business calculations and aggregations in your data model. Additionally, you can use native SQL when connecting to SQL databases, and Python/R for advanced analytics.
Suggested Q&A
General · Class 12- GeneralClass 12Electric Field at Centre of Ring with Non-Uniform Charge Distribution. Four quadrants carry linear charge densities: +2λ, −2λ, +λ, −λ. Find electric field at centre.
- GeneralClass 12P°(hexane) = 408 Torr, P°(heptane) = 141 Torr. x(hexane) = 0.300. Find Y₆ and Y₇.
- GeneralClass 122N₂O₅(g) → 4NO₂(g) + O₂(g). Initial P = 50 mmHg; P at 30 min = 87.5 mmHg. Find P at 60 min.
- GeneralClass 12What is the difference between psychosis and neurosis?
- GeneralClass 12What is the difference between prism and a pyramid?
- GeneralClass 12What is the difference between phrase and clause?