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.

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

Hi,

What result do you get with this calculated column formula?

=SAPCrosstab1[Gew. Ende]-TODAY()