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] ) 
)
parry2k's avatar
parry2k
Super 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. 

elenton's avatar
elenton
Helper II
7 years ago

parry2k ive got it working now thanks, it is definalty a formatting issue which i will play with to see if i can get a better fix, but for now i just created another column in my date dimension that is just a date field and used today-1 to go back one day which looks to have worked.