Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help with query Dax or Power query

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?

Need Help

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    Anonymous A DAX calculation would be:

    Days Open Column = ([INC_RESOLVED_AT] - [INC_OPENED_AT]) * 1. + 1
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Can anyone help me with this ?

     

    Thanks