DateDiff Incorrect output

[tgalla01]

The code (Top part of attached image) was created to calculate the difference of the First_Order_Date from the Second_Order_Date which if done correctly should give and output of the number of days from the first order to the second order, however the output (example shown by blue arrow) is giving a very incorrect number, giving a -295 output though the orders were put in on the same day, meaning the correct output should be 0. If anyone could give an input as to the issue and a way to resolve it that would be much appreciated. Thanks!

[Anonymous]

Hi @tgalla01,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[lbendlin]

This looks like a calculated column.  You may need to expand the filter context beyond the current row.

[tgalla01]

Yes it is a calculated column. Here is more insight on that particular piece and obviously has been a struggle. Designating the second order using this logic has been the only real way that I've been somewhat able to pin down the second order a customer has placed. 

[lbendlin · Accepted solution]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[tgalla01]

I appreciate and thank you for the review. I see my error and will make the modification.