Forum Discussion

pandakillsalot's avatar
pandakillsalot
Helper II
8 years ago
Solved

Got wrong date from slicer

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

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    pandakillsalot,

    Change your measure to the following:

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



    Regards,
    Lydia

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    pandakillsalot,

    Change your measure to the following:

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



    Regards,
    Lydia