Syntax
ALL( {<table> | <column>[, <column>[, <column>[,…]]]} )
Tutorial with example
In this tutorial we go through the ALL and ALLSELECT functions.
Video Keynotes:
01:14 ALL function
06:20 ALLEXCEPT function
Download example file:
Link to PBI file: here.
Remarks
This function is not used by itself, but serves as an intermediate function that can be used to change the set of results over which some other calculation is performed.
Was this helpful?
Hi Ruth, I’m having trouble downloading the file due to certificate issues. Can you check this out and repair it?
Further I’m having trouble using the sample files (Excel) due to the fact that I use Excel 2010 and don’t have all the tools you use. What do I need to do to write DAX in Excel using PowerQuery? Is there an video for? Keep up the good work.
Kind regards
Eric
Hi,
I need to review all my download links!Can you try to download it from home?
You cant write DAX in Power query only M!
/Ruth