Forum Discussion

Dyke211's avatar
Dyke211
Icon for Helper I rankHelper I
2 years ago

Calulcuating Date difference in days within same column

Hello Guys, i want to get the number of days between the dates within same column in DAX. FOR INSTANCE.. wOULD LIKE TO REPLICATE THIS IN POWER bi
Dyke211's avatar
Dyke211
Icon for Helper I rankHelper I
2 years ago

tHE oBJECT ISNT MEANT TO BE A DATE ITS ACTUALLY UNIQUE VALUES OF THINGS

  • quantumudit's avatar
    quantumudit
    Icon for Super User rankSuper User
    2 years ago

    Hi Dyke211 

    Please correct me if I have misunderstood the issue. However, you need a date field to calculate the "days" difference between subsequent rows. If you wish to retain it as a text field, then you must convert it into a date type during the calculation to determine the days difference.

    If that is the case, then simply use DATEVALUE(Assets[Date]) instead.