Got wrong date from slicer

[pandakillsalot]

Hi all,

The date in my table is stored in the format  "mm--dd--yy"  as shown in the picture. When I wrote a measure as "CALCULATE(DIVIDE(StressProduction[NumberPassesCorrect],StressProduction[Unique SN count],0), DateTable[Date] <= 1/1/2018)", I got no data showing up. And the latest date stored is 1/1/2018. However, when I did "CALCULATE(DIVIDE(StressProduction[NumberPassesCorrect],StressProduction[Unique SN count],0), DateTable[Date] > 1/1/2018)",  I got all the data I want.

Does anyone have any thoughts about what's happening?

Best,

Yilin

[v-yuezhe-msft · Accepted solution]

@pandakillsalot,

Change your measure to the following:

CALCULATE(DIVIDE(StressProduction[NumberPassesCorrect],StressProduction[Unique SN count],0), DateTable[Date] <= DATE(2018,1,1))

Regards,
Lydia