Date Math bug?

[Scottnap]

Confounded by this issue and hoping someone can help!  I'm having a problem with date math in a Power BI Measure.

I have a measure that calculates the difference (in days) between TODAY() and a Created date in a table column.  The Created Data is stored as Date/Time format, Short Date.

Clearly 198 days have not elapsed between TODAY() (01/11/2023 at time of posting) and the created date (12/20/2022).  It should be 22 days.  The Measure calculation is this.

Oddly enough, I created another measure (DaysElapsed) as a sanity check, and used the same values and the caluclation worked fine!

I've noticed the issue appears when I'm subtracting a date from last year but works fine when I'm subtracting a date from this year.  Stumped.

[Scottnap]

Thanks you for the quick response!  That worked!  

[sevenhills · Accepted solution]

Try this and see ... 

Days Since Created = ABS( DATEDIFF(TODAY(), SELECTEDVALUE(TableDateMathBug[Created]), DAY))