Forum Discussion

beerygaz's avatar
beerygaz
Frequent Visitor
8 years ago
Solved

DATEDIFF doubles result

I have a strange situation using DATEDIFF to calculate seconds between two datettime fields.  I add a new column in my report called 'Duration':   Duration = DATEDIFF([Alert_Start],[Alert_Finish],S...
Need Help
  • shill1000's avatar
    shill1000
    8 years ago

    The DAX is OK, are you sure it's not a data issue? Is it counting multiple records against the same index etc? Sample data will proabbly be more help here than anything else.

shill1000's avatar
shill1000
Helper IV
8 years ago

The DAX is OK, are you sure it's not a data issue? Is it counting multiple records against the same index etc? Sample data will proabbly be more help here than anything else.

  • beerygaz's avatar
    beerygaz
    Frequent Visitor
    8 years ago

    Thanks for the hint, it seems I had duplicate rows in my database (although why these were being summarised is beyond me) but removing the duplicate rows solved my problem.