Working with date and time values.
Challenge No. 75: In the Question table, the order date for different products is provided (determined by positive quantity).
Solved using:DAX, Excel (CHOOSECOLS, FILTER, HSTACK), Power Query (Table.AddColumn, Table.Group, Table.SelectRows), Python, R, and SQL.
Challenge No. 63: In the Question table, sales information including Date, Product Name, and Quantity is provided without any separators.
Solved using:Excel (CHAR, HSTACK, LAMBDA), Power Query (List.Contains, Table.Combine, Table.FromRows), Python, R, and VBA.
Challenge No. 38: In the question table, the visiting dates for all 4 agents are provided.
Solved using:Excel (AVERAGE, DROP, EOMONTH), Power Query (List.Transform, Table.AddColumn, Table.Group), Python, and R.
