DateDiff unexpected results

Hi setis,

 I tested with above DAX formula, it returns correct datediff results.

In your scenario, please check if the results are correct in Data view as shown in above screenshot. If you have several duplicate rows, when you add fields into table visual, [Diff PostingDate & DueDate] might be aggregated which returns larger values.

---

On a separate note, is it possible to show the DATEDIFF values on positive and negative values? If Posting Date is after the due date, I would like a positive value and not 0

 

---

You can use a IF condition in such a scenario. Similar to:

Diff PostingDate & DueDate =
VAR datediffval =
    DATEDIFF (
        'Sample Table'[Due Date].[Date],
        'Sample Table'[Posting Date].[Date],
        DAY
    )
RETURN
    IF (
        'Sample Table'[Posting Date].[Date] > 'Sample Table'[Due Date].[Date],
        ABS ( datediffval ),
        datediffval
    )