topic Re: Need Help with date difference between values within a column in DAX Commands and Tips

Need Help with date difference between values within a column

Dyke211 — Wed, 24 Apr 2024 16:31:18 GMT

HI Guys, can anyone give me a good dax measure of calculated column that shows different in the number of days between reported events within a single column such that if i slice based on Assettype, i can see the current date different between the group of asset class in a dynamic way. That means Machine A will show me the number in days of date different between only its class type ansd Machine B will show me the date difference row by row between its own class....

Re: Need Help with date difference between values within a column

tamerj1 — Thu, 25 Apr 2024 04:28:53 GMT

Hi Dyke211

please try

Number of Days Diff. =
VAR CurrentDate = 'Table'[ReportedEvent]
VAR CurrentTypeDates =
CALCULATETABLE (
VALUES ( 'Table'[ReportedEvent] ),
ALLEXCEPT ( 'Table', 'Table'[AssetType] )
)
VAR previousDate =
MAXX (
FILTER ( CurrentTypeDates, 'Table'[ReportedEvent] < CurrentDate ),
'Table'[ReportedEvent]
)
RETURN

DATEDIFF ( COALESCE ( previousDate, CurrentDate ), CurrentDate, DAY )

Re: Need Help with date difference between values within a column

ThxAlot — Wed, 24 Apr 2024 19:43:12 GMT