Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Date Difference First Date Column A & Last Date Column B

How do you calculate the date difference between the first date in one column and the last date in another column for unique values ?

 

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

    For a calculated column, please refer to:

    diff = DATEDIFF(MIN(table2[ColumnA]),MAX(table2[ColumnB]),DAY)

     

    For a calculated measure, please refer to:

    diff measure = DATEDIFF(CALCULATE(MIN(table2[ColumnA]),ALL(table2)),CALCULATE(MAX(table2[ColumnB]),ALL(table2)),DAY)

     

    Best regards,

    Yuliana Gu

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

     

    For a calculated column, please refer to:

    diff = DATEDIFF(MIN(table2[ColumnA]),MAX(table2[ColumnB]),DAY)

     

    For a calculated measure, please refer to:

    diff measure = DATEDIFF(CALCULATE(MIN(table2[ColumnA]),ALL(table2)),CALCULATE(MAX(table2[ColumnB]),ALL(table2)),DAY)

     

    Best regards,

    Yuliana Gu