Forum Discussion

vanessa's avatar
vanessa
Post Patron
9 years ago

Dynamic Last 7 day

  I am trying to calculate the sales for the last 7 days, but the last 7 days will be dynamic, based on the date selected in a slicer. eg. if the date selected in the slicer is 2017/07/18, then the...
Need Help
Show and Tell
vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

vanessa so you saying hardcoded works or doesn't?

 

are you sure you have the correct date format?

vanessa's avatar
vanessa
Post Patron
9 years ago

vanessafvg hardcoding the value works. Yes the date format is correct.