Is there way I can do a "for loop" in Kusto query?

Context: I'm trying to compute Daily Active Users/Monthly Active users(last 30days). For eg: if my Daily active users on 1st May 2022 is 1200, and Monthly active users for last days is 1600 (i.e. Last 30 days = 1st April 2022 to 1st May 2022). And I want this data rolling for up to 30 days in the past. More explanation below.

Current query: I'm able to get Daily active users and Monthly active users(last 30 days) for today's date(using now()) from below query.

Events
| AccountId == 'xyz'
| where timestamp between ((now()-31d)..(now()-1d))
| summarize MonthyDCount = dcount(userId) by AccountId, To = To=format_datetime((now()-1d),"dd-MM-yyyy"),From=format_datetime((now()-31d),"dd-MM-yyyy")
| join (Events
         | AccountId = 'xyz'
         | timestamp > ago(3d)
         | summarize dailyDcount = dcount(userId) by AccountId, DAUDate=format_datetime(timestamp,"dd-MM-yyyy"))
on ($left.AccountId == $right.AccountId) and ($left.To == $right.DAUDate)
| project AccountId, To, From, DAUDate, MonthlyDcount, dailyDcount

Current Result:

Expected Results:

Is it possible to achieve this in Kusto??

Thanks!