Forum Discussion

elenton's avatar
elenton
Icon for Helper II rankHelper 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] ) 
)
parry2k's avatar
parry2k
Icon for Super User rankSuper 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
Icon for Helper II rankHelper 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
    Icon for Super User rankSuper 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
      Icon for Helper II rankHelper 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

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        7 years ago

        elenton logically it should work if you have date dimension. May be there is any filter or something which is makign it not to work. Please reach out if you still need help.