Forum Discussion

abehrmann24's avatar
abehrmann24
Regular Visitor
6 years ago
Solved

dynamics incident resolution time

i am trying to calculate the time in days  to resolve an incident.  

 

The incidents have a one to many relationship with the resolution. So i am trying to create a new column on the incidents table using related ()  to bring over the first resolution for the incident.  

 

Then do a datediff( createdby,resolveddate,day)  but i am unsecessful in get

 

Any help on this would be appreciated.  

Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    abehrmann24 , If you want bring data from another table

    Way 1: Data in a 1 side of 1 to Many. Means in master or header table

    Item Name = RELATED('item'[Brand]) // from item to sales .need to have relation
    // Work even with realtion
    City Name = maxx(FILTER(geography,geography[City Id]=Sales[City Id]),geography[City]) // From geography to sales

    // reverse

    City Name = maxx(FILTER(Sales,geography[City Id]=Sales[City Id]),Sales[City]) // From sales to geography

     

    // from date to sales

    Month Name = LOOKUPVALUE('date'[Month Year],'date'[Date],Sales[Sales Date])

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    abehrmann24 , If you want bring data from another table

    Way 1: Data in a 1 side of 1 to Many. Means in master or header table

    Item Name = RELATED('item'[Brand]) // from item to sales .need to have relation
    // Work even with realtion
    City Name = maxx(FILTER(geography,geography[City Id]=Sales[City Id]),geography[City]) // From geography to sales

    // reverse

    City Name = maxx(FILTER(Sales,geography[City Id]=Sales[City Id]),Sales[City]) // From sales to geography

     

    // from date to sales

    Month Name = LOOKUPVALUE('date'[Month Year],'date'[Date],Sales[Sales Date])