Subtract Number of Days

[AdamD123]

Hello,

I am trying to find out the number of days difference between two dates. I thought this would be a fairly easy subtraction but I seem to be struggling due to the dates coming from different data sets. I have looked through previous queries but they all appear to be from the same dataset.

I would like to subtract the order date from the posting date, so for example the top one will show as 1 day. 'Order_date' is from one dataset and 'Posting_date' is from another.

Can anyone advise please?

Kind regards,

Adam

[ryan_mayu · Accepted solution]

@AdamD123 

maybe you can try this

datediff(max(orderdate),max(postingdate),day)

[ryan_mayu · Accepted solution]

@AdamD123 

maybe you can try this

datediff(max(orderdate),max(postingdate),day)

[AdamD123 · Accepted solution]

Hi Ryan,

This seems to have worked, thank you ever so much!

[ryan_mayu]

you are welcome

[lucadelicio]

Can you prepare and upload a pbix example with a fake data but the same model?

Thank you

[AdamD123]

I wouldn't know how to do this sorry.

[lucadelicio]

Hi @AdamD123 ,

you have to create a CALCULATED COLUMN using DIFFDATE() function.
Refer to this documentation:
https://learn.microsoft.com/en-us/dax/datediff-function-dax

Try to use this calculated column formulas.
Column =
DATEDIFF([Order_Date], [Posting_Date], DAY)

Mark as a solution if i help you to resolv your problem

[AdamD123]

Hello Luca,

Thank you for your reply. I have done this but get the below:

[lucadelicio]

You have to respect the syntax of the code!
Helping with intellisense that suggest you the wright way, put the table name before the comun name.
Something like this:
DATEDIFF(Tablename[Order_Date], Tablename[Posting_Date], DAY)

[AdamD123]

I think I understand what you are explaining but that is the issue, the one column does not appear to select because they are from different date sets: