Rolling 30 days in service now

[Anonymous]

Hi Guys,

I am doing replicate report in power bi which has already be done using explore analytics

Data Source: Service now

I want to capture and freeze the backlog incidents in a separate tables on daily basis at the end of the day at 11.59 pm,

if the backlog incidents get resolved on next day and day after, it should not impact on yesterday backlog count it should freeze the yesterday count, and also the backlogs count should reflect in graph on daily basis

[v-yuta-msft]

@Anonymous ,

I want to capture and freeze the backlog incidents in a separate tables on daily basis at the end of the day at 11.59 pm,

if the backlog incidents get resolved on next day and day after, it should not impact on yesterday backlog count it should freeze the yesterday count, and also the backlogs count should reflect in graph on daily basis

---

Generally you can create measures using dax function to achieve this requirement. If possible, please share the sample data and expected result.

Regards,

Jimmy Tao