https://powerpartners.pro/en/power-query-vs-dax/#:~:text=So%2C%20what%20is%20the%20difference,and%20DAX%20for%20data%20analysis
Data Analysis Expressions (DAX) is a library of functions and operators that can be combined to build formulas and expressions in Power BI, Analysis Services, and Power Pivot in Excel data models.