You need to create a status field in Power Query for any order that has 30 days between the start of the order and the ship date. It should provide a status value of "Over 30 Days." Which built in function can you use? Append Merge Conditional Column Index Column You are seeing bad data results that do not match the expected record counts of the multiple datasets that you connected to Power BI. What is the first thing to check in the data model? Confirm each data set loaded into the model as expected, confirm that auto detect did establish the correct relationships. Merge the files in another program before bringing them back into Power BI Start back over and see if you have the same results. Assume your counts are wrong and that report is correct as is. When performing a custom sort which field do you select first to sort the name of the month field oy Sorting.SortNum? MonthNum AmtOrdered MonthName Sorting.SortNum What is the most universal data role? data worker data analyst data engineer data scientist