Forum Discussion

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)

Hopefully someone can help me out! Thanks alot!

Greetings

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.

5 Replies

amitchandak
Super User
6 years ago
Anonymous , stop .date and try

Gew.Ende_Hilf_Differenztage = DATEDIFF(TODAY();SAPCrosstab1[Gew. Ende];DAY)
- Anonymous
  Not applicable
  6 years ago
  Nothing changed... still I have the two wrong differences!
  - amitchandak
    Super User
    6 years ago
    Anonymous ,Can you share a sample pbix after removing sensitive data.
v-juanli-msft
Community Support
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
Super User
6 years ago
Hi,

What result do you get with this calculated column formula?

=SAPCrosstab1[Gew. Ende]-TODAY()