This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
When using functions that process Tables of data, the table must come from?
Unfiltered data sources
Any data source but not collections
Single column tables only
The functions accept any table. The table might come from a tabular data source, a collection, or a Table function.
The aggregate functions support the following inputs?
Only Table data with an expression - Example Sum(Table, Column1)
Only Manual data - Example Sum(1,2,3)
Both Table data and Manual data
Only Table data without an expression - Example Sum(Table)
What function can you use in the formula for the ForAll function to overcome not being able to use Set and UpdateContext?
You can use Set and UpdateContext in ForAll.
You can use the Collect function.
You can use the ForAllVariable function.
You can use the Patch function.
You must answer all questions before checking your work.
Was this page helpful?