Forum Discussion

Jeffrey_VC's avatar
Jeffrey_VC
Icon for Helper III rankHelper III
2 years ago
Solved

Datediff with argument

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's avatar
    Kaviraj11
    2 years ago

    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
)
       

2 Replies

  • Kaviraj11's avatar
    Kaviraj11
    Icon for Solution Sage rankSolution Sage
    2 years ago

    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
)