topic Datediff with argument in DAX Commands and Tips

Datediff with argument

Jeffrey_VC — Tue, 20 Aug 2024 12:22:32 GMT

Hello everyone,

I looking for some help.

In my dataset I have 1 colum with a "create date" and 2 other colums "current" and "New". (This are serialnumbers.)

When In the table "current" a same number exist in the colum "New" I need to calculate the amount of days between the different days.

Anyone any idea to solve this?

Thnx.
Jeffrey

Kaviraj11 — Tue, 20 Aug 2024 13:29:59 GMT

Hi,

You can try this:

Create a Calculated Column for the Matching Serial Numbers: First, create a calculated column to identify the matching serial numbers between the “current” and “new” columns.
```
MatchingSerial = 
IF(
    'Table'[current] IN VALUES('Table'[new]),
    'Table'[current],
    BLANK()
)
```
Create a Calculated Column for the Create Date of the Matching Serial Numbers: Next, create a calculated column to get the create date for the matching serial numbers.
```
MatchingCreateDate = 
CALCULATE(
    MAX('Table'[create date]),
    FILTER(
        'Table',
        'Table'[new] = EARLIER('Table'[current])
    )
)
```
Create a Calculated Column for the Number of Days Between Dates: Finally, create a calculated column to calculate the number of days between the create dates.
```
DaysBetween = 
DATEDIFF(
    'Table'[create date],
    'Table'[MatchingCreateDate],
    DAY
)
```

Jeffrey_VC — Wed, 21 Aug 2024 08:28:54 GMT

Kaviraj11 thnx this works for me.