date difference using over function

[Dennis Vavasis 2]

Hi Spofire gurus,

I am trying to translate a Power BI dashboard(which i designied)to Spotfire and I have this very simple task. While I am more proficeint in Spotfire II cannot understand what I am msiing here....

In short , I want to sum the total duration of trips per employee. In the attached example the toltak summary is 22 + 9 = 31 days. Using a DAX expression I could calculate this.

I have a problem doing this with an OVER calculated ecxpression. I just want the sum of duratiion disregarding the activities.

 

Thnx

D

[Khushboo Rabadia]

You can use RowId() function to get the min rowid per employee per trip and sum up only those durations like

Sum(case when RowId()=Min(RowId()) OVER ([EMPLOYEENUMBER],[trip_ID]) then [Duration] end)