At the level of a business user in Power BI, you are going to use DAX in two main ways – creating calculated columns and measures.
If you are importing, cleaning, and transforming your data in Power Query then you are using the M language. After that is done and you are about to start analyzing information and ask questions using your data, then you are in the DAX territory.
Learn more about Power BI and Power Query: https://centida.com/index.php/blog/
Keywords:
#DAX #PowerBI
#Excel #difference