Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Splitting table rows from value

Hello,   I need to calculate the duration between Events for each particular user working in a specific file in a datasource that contains info from multiple users. Sample table below.   The goal...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try

    DateDiff = 'view-activated collected'[DateTime] - MINX(FILTER('view-activated collected',
					'view-activated collected'[DocPath] = EARLIER('view-activated collected'[DocPath]) 
				&& 'view-activated collected'[Username] = EARLIER('view-activated collected'[Username]) 
				&& 'view-activated collected'[DateTime] > EARLIER('view-activated collected'[DateTime])
				),'view-activated collected'[DateTime])
amitchandak's avatar
amitchandak
Super User
6 years ago

Try like. Add or remove conditions as per need

Datediff = table[datetime] = minx(filter(table,table[file name] = earlier(table[file name]) && table[user name] = earlier(table[user name])
										 && table[datetime] > earlier(table[datetime])),table[datetime])

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    thank you for such quick reply  , 

    I am getting an error of type

    "Too few arguments were passed to the MINX function. The minimum argument count for the function is 2."

    the actual formula I am using is this

     

    DateDiff = 'view-activated collected'[DateTime] = MINX(FILTER('view-activated collected','view-activated collected'[DocPath] = EARLIER('view-activated collected'[DocPath] && 'view-activated collected'[Username] = EARLIER('view-activated collected'[Username]) && ('view-activated collected'[DateTime] > EARLIER('view-activated collected'[DateTime])),'view-activated collected'[DateTime])))

     

    amitchandak

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Try

      DateDiff = 'view-activated collected'[DateTime] - MINX(FILTER('view-activated collected',
					'view-activated collected'[DocPath] = EARLIER('view-activated collected'[DocPath]) 
				&& 'view-activated collected'[Username] = EARLIER('view-activated collected'[Username]) 
				&& 'view-activated collected'[DateTime] > EARLIER('view-activated collected'[DateTime])
				),'view-activated collected'[DateTime])
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        It is working very well, thank you.

         

        Found an unintended consequence of the requirement, though.

        Can the last DateDiff calculation for the last entry for user+docpath be set to 0?