Project 1 - Data Cleaning and Transformation using Pivot Table and Charts
1. The Syntax of the UNIQUE Function is =UNIQUE(array, [by_col], [occurs_once]).
2.
3. If C5 = 2,the output of =SWITCH(C5,1, "Poor",2, "OK",3, "Good","?") is "OK".
4.
5. M Language is used for power query.
6.
Power query
9.count rows 61 rows