DAX Measure to subtract dates in different rows by group

leodm — Fri, 10 Mar 2023 14:19:12 GMT

Database sample:

I need a DAX Measure (since I'll work with FILTERED VALUES) to calculate the difference between consecutive dates by Squad.

Thank you in advance (=

Re: DAX Measure to subtract dates in different rows by group

Jihwan_Kim — Sun, 12 Mar 2023 07:05:52 GMT

Hi,

Please check the below picture and the attached pbix file.

Expected result days: = VAR _current = MAX ( Data[DateTime] ) VAR _previous = CALCULATE ( MAX ( Data[DateTime] ), OFFSET ( -1, ALL ( Data[Squad], Data[DateTime] ), ORDERBY ( Data[DateTime], ASC ), KEEP, PARTITIONBY ( Data[Squad] ) ) ) RETURN IF ( HASONEVALUE ( Data[Squad] ), DATEDIFF ( _previous, _current, MINUTE ) / ( 24 * 60 ) )

topic Re: DAX Measure to subtract dates in different rows by group in DAX Commands and Tips

DAX Measure to subtract dates in different rows by group

Re: DAX Measure to subtract dates in different rows by group