Forum Discussion
lcasey
Post Prodigy
Post ProdigyDATEDIFF, 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...
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
Community Champion
Community ChampionTODAY( ) 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
)
lcaseyYes 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!
- lcasey
There are no dates past 11/18/2016 so I am not sure why datediff doesnt work