Help with query Dax or Power query

[Anonymous]

Hi all,

Imagine the situation:

i have a table like this:

Due this situation , to have a backlog table , i need to generate each entry with the date depending how many days the incident was bettween open and resolved. 1 entry in the table per day opened.

If the diff betten open and resolved is 0 (resolved same day) is 1

if no resolve time so ticket still opened compare with today.

Could you help me to create doesn't matter if is DAX or power query?

[Anonymous]

Can anyone help me with this ?

Thanks

[Anonymous]

Hi @Greg_Deckler ,

Thanks for your answer but is not what I'm expecting. For sure , i didn't explain very well. Lets try again with another example.

Due the following scenario:

You can see i have incient number , open and resolved columns. And as you can see the column resolve could or not be filled.

What i need is this:

Create a new table that is create depending the open and resolve time and if doesn't have any resolved time, have to take the current day.

Is this possible to create in DAX or Power Query?

I hope you can help me.

Thanks

[Greg_Deckler · Accepted solution]

@Anonymous Sure:

Column = IF([INC_RESOLVED_AT] = BLANK(),TODAY(),[INC_RESOLVED_AT])

Also, you might find these links helpeful as well:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

[Anonymous]

Thats exactly what i need , thansk you so much 🙂

[Greg_Deckler]

@Anonymous A DAX calculation would be:

Days Open Column = ([INC_RESOLVED_AT] - [INC_OPENED_AT]) * 1. + 1