学习Power Pivot的DAX建模理论及实践可参阅Italians的有关著作,Italians有专门的官网链接:https://www.sqlbi.com/books/,可上去了解,如:《The Definitive Guide to DAX》、《Analyzing Data with Power BI and Power Pivot for Excel》、《DAX Patterns 2015》(2019年也要出第二版)几本著作等。Power Query就是Miguel Escobar和Ken Puls 的《Master Your Data with Excel and Power BI: Leveraging Power Query to Get & Transform Your Task Flow》和Gil Raviv的《Collect, Combine, and Transform Data Using Power Query in Excel and Power BI》这两本更具理论性和实操性。谢谢!