Forum Discussion

elenton's avatar
elenton
Helper II
7 years ago
Solved

Previous Days Orders

Hi I want to get all orders from the previous day.  However if i use now() - 1 it pulls the time in which dosent link on my date table. If i format the date it ends up as a string whcih is inc...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    elenton seems lke you have date dimension in your model, if yes then update measure

     

    Prev day sales = 
CALCULATE ( SUM( Table[Sales] ), 
PREVIOUSDAY( Date[Date] ) 
)
elenton's avatar
elenton
Helper II
7 years ago

parry2k sorry i missed that bit.

I think the issue may be that the date format i am trying to link on is YYYY-MM-DD which is different to the fomat that the variable is producing.

When i try to format the variable the same it is then converted to a string so data type mismatch. So im not sure how to then convert it back into a date.

 

Or is there something more obvious im missing?

parry2k's avatar
parry2k
Super User
7 years ago

elenton what exact error your are getting? Date function you used for var should return a date.

  • elenton's avatar
    elenton
    Helper II
    7 years ago

    parry2k this is the error that comes up

    Error Message:
    MdxScript(Model) (63, 5) Calculation error in measure '_Alert Measures'[_Daily Calls Total]:
    DAX comparison operations do not support comparing values of type Date with values of type Text.
    Consider using the VALUE or FORMAT function to convert one of the values.

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      elenton seems lke you have date dimension in your model, if yes then update measure

       

      Prev day sales = 
CALCULATE ( SUM( Table[Sales] ), 
PREVIOUSDAY( Date[Date] ) 
)
      • elenton's avatar
        elenton
        Helper II
        7 years ago

        parry2k Thats not bring back any data but i will have a play around with that approach see if i can get it working thanks