Hi guys! Need your help. I'm struggling to formulate the % change in D A X. I'm trying to have a measure for Daily, Week of the year, Monthly, Quarterly and yearly for comparative purposes. This is my data.
My first option is to get the previous value for daily to get the %daily change. This is my formula,
for
Sales= Sum([ ])
then
for
Previous Sales = CALCULATE([Sales],DATE ADD('Calendar'[DATE],-1,DAY))
Take note of the fact date and Calendar date,they are different because "Date add" don't usually work in fact date or non continuous that's why I created Calendar table(continuous)
This is the outlook. It did not met what I want. The Blank cells are not part of Fact Date.
How Can I remove those blanks? or Should I change my formula? My data sets? Please need your help!!!
Thank you!
