take_any
take_any will return a random row from the dataset
Return only one random row
IntuneDevices
| summarize take_any(*)
Return only one random row with specific columns

Use with by, returns a random row for each distinct value from that column

Last updated