Forum Discussion

lcasey's avatar
lcasey
Icon for Post Prodigy rankPost Prodigy
9 years ago
Solved

DATEDIFF, TODAY doesnt work.

Hello,   When using This formula: Offline = DATEDIFF(Max('hardware'[Last Count]),Today(),DAY) I get an error   The start date cannot be greater than the end date.  I should get a 0 when the two d...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    TODAY( ) should not be a problem.

    Try this Measure which should work!

    If it works you have days in the [Last Count] column that are later than today!

     

    Offline =
    SWITCH (
        TRUE (),
        TODAY () < MAX ( 'hardware'[Last Count] ), -1 * DATEDIFF ( TODAY (), MAX ( 'hardware'[Last Count] ), DAY ),
        TODAY () > MAX ( 'hardware'[Last Count] ), DATEDIFF ( MAX ( 'hardware'[Last Count] ), TODAY (), DAY ),
        0
    )

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

TODAY( ) should not be a problem.

Try this Measure which should work!

If it works you have days in the [Last Count] column that are later than today!

 

Offline =
    SWITCH (
        TRUE (),
        TODAY () < MAX ( 'hardware'[Last Count] ), -1 * DATEDIFF ( TODAY (), MAX ( 'hardware'[Last Count] ), DAY ),
        TODAY () > MAX ( 'hardware'[Last Count] ), DATEDIFF ( MAX ( 'hardware'[Last Count] ), TODAY (), DAY ),
        0
    )

lcasey's avatar
lcasey
Icon for Post Prodigy rankPost Prodigy
9 years ago

Yes that works as expected.    Wow, a simple datediff doesnt work.

 

It  seems counter productive to write several lines of code just to get the difference between two dates.

 

Thank you very Much!!!  Hopefully Microsoft will hire better Power BI developers so that Huge lines of code are not eedd for everything.

 

Thanks!