Forum Discussion
DATEDIFF incorrectly calculating
Hello Power BI Community! I can't tell you all how much I have loved getting to know how to use Power BI. Thank you for eveyone's contributions on this forum. It's my go to stop for help and most...
Hi Anonymous,
Please check if you have more than one row that contains the same PO and Shipped dates. Your Days to Ship might have been aggregated.
PO Date Shipped Date Days to Ship-incorrect Days to Ship-correct Number of Rows? 2/7/2018 2/28/2018 105 21 5 1/17/2018 2/23/2018 74 37 2
Very strange. I recreated this as a calculated column and got the right answers. Can you confirm that your date columns are tagged as Date columns and not something like text?
Yes, just reconfirmed that the columns are tagged as date columns. Also doubled checked in query editor as well and all my date columns are correctly tagged as date columns. What is strange is that it’s calculating correctly 95% of the time.
Anonymous- One thing that I did differently (I tested with the exact same dates) is that I did not include the ".[Date]" portion when referencing my columns. See if that makes a difference.
I removed the ".[Date]" and unfortunately that doesn't solve the issue.
That's a weird one, especially since I can't recreate with the same dates. If you have a Pro account, open a support ticket.