SharePains by Pieter Veenstra on MSN

CountRows, CountIf, CountA and Count in Power Apps

How often would you like to count the number of records without really wanting to load all the records that exist in a list ...
When working with address data, you may encounter situations where you need to merge multiple columns, such as address, town, and postcode, into a single column. Power Query makes this task a breeze.