Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Datediff

Datediff shows sometimes not the  correct difference and Im wondering why?   This is my calculated column: Gew.Ende_Hilf_Differenztage = DATEDIFF(TODAY();SAPCrosstab1[Gew. Ende].[Date];DAY)   ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    If date is duplicated, when creating a calculated column, it will sum days for duplicated rows.

    For example

    column

    Column = DATEDIFF([today],'Table'[date],DAY)

    You can try a measure

    Measure = DATEDIFF([today],MAX('Table'[date]),DAY)

today = DATE(2020,6,30)

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , stop .date and try

Gew.Ende_Hilf_Differenztage = DATEDIFF(TODAY();SAPCrosstab1[Gew. Ende];DAY)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Nothing changed... still I have the two wrong differences!

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous ,Can you share a sample pbix after removing sensitive data.