Table of contents Overview Zero to Hero search take where summarize arg_max count, countif dcount, dcountif take_any distinct project project-reorder project-away project-rename project-keep sort by extend strcat Hero to Expert let join union pack summarize make_bag make_set, make_list evaluate bag_unpack pivot mvexpand set_difference case 💻 Examples Device Inventory Device OS version Same AAD Device ID and Intune Device ID