Datediff with argument

[Jeffrey_VC]

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 · Accepted solution]

Hi,

You can try this:

1. 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()
   )

2. 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])
       )
   )

3. 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]

@Kaviraj11  thnx this works for me.