Excel 2013 Power BI Tools Part 11 - DAX Functions: FILTER, RANKX and EARLIER

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andy Brown

https://www.wiseowl.co.uk - You can download the files that you need to follow this tutorial from https://www.wiseowl.co.uk/blog/s443/tutorial-links.htm.

When you've got to grips with the CALCULATE function in PowerPivot, why not stretch yourself by having a look at some of the other ways in which you can play about with pivot table data? This tutorial looks at the FILTER function (which provides another way to play about with query context), the RANKX function (for sorting) and the hard-to-understand EARLIER function.

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, PowerPivot, SQL, Reporting Services, Analysis Services, Integration Services and other .NET, SQL Server and Microsoft Office applications.

Тэги:

#Microsoft_Excel_(Software) #Business_Intelligence_(Industry) #PowerPivot #wise_owl #excel_2013

Скачать видео