NYNJ Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

Time Stamp of Status Change

  • 1.  Time Stamp of Status Change

    Posted Feb 12, 2019 05:12 PM
    I am trying to come up with a way to create measure that will show the time stamp of a item in Share Point list item when it entered into a new status

    I was able to make a query to the list that shows all the version history for each every item in the list

    I have a measure that will show me the time stamp for the row with the most recent update
    MAX('SharePointListTable'[ModifiedDate]) I want to find the first date recorded when a Status column = a certain value. I was trying

    CALCULATE ( MAX ('SharePointListTable' [ModifiedDate] ), 'SharePointListTable' [Status] = "Complete"
    CALCULATE ( MIN ('SharePointListTable' [ModifiedDate] ), 'SharePointListTable' [Status] = "Complete"

    then be able to do a DIFFDATE for how long it was in that that

    Anyone got any ideas?

    Mark Paradis
    Project Manager
    Rockleigh NJ