Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • danextian's avatar
    danextian
    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 DateShipped DateDays to Ship-incorrectDays to Ship-correctNumber of Rows?
    2/7/20182/28/2018105215
    1/17/20182/23/201874372
Anonymous's avatar
Anonymous
Not applicable
8 years ago

I am sorry for the delayed response. I will check that and get back to you on if that solves the issue.

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

Have you resolved it? If yes, would you please accept the helpful suggestion as an answer or sharing your resolution so that it can benefit more users?

 

Regards,

Yuliana Gu