7 day moving average
I really have zero DAX experience. I even tried to add a column and then enter an Excel formula at first. Of course after digging in a little I realized that it doesn't work that way in this case. I am using direct query from a SQL database. My query data looks like the below table - and I am trying to add the final 7 day moving average column. In short, I need to sum the quantity ordered on each date and then calculate the 7 day moving average on those sums. I would then add that data to the line graph below. What is the best way to go about doing this? In addiiton, is there a particular trainng course I can take to come up to speed?
