Forum Discussion
Anonymous
8 years agoNot applicable
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...
- 8 years ago
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
Ashish_Mathur
8 years agoSuper User
Hi,
What result do you get when you write this calculated column formula
=Data[Shipped Date]-Data[PO Date]