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