I have a date slicer that generally is used for MTD. For example my slicer shows March 1st - March 20th and a have a single bar on a bar graph that shows the number of widgets sold for that time period. What I need to add is the number of widgets sold Feb. 1st - Feb 20th as a bar, Jan1st- Jan20th as a bar and so on for the 12 previous months.
I would need this to change based on the selection of the slicer, so if I change it to Mar 1st - Mar 25th the other data points would adjust for 1st-25th in their respective months.
How would I go about accomplishing this??? Any and all suggestions are welcome.
Solved! Go to Solution.
Thank you @wdx223_Daniel ! Could you help me understand what it is this formula does? Variables for Year, Month and Day I wouldn't think would be hardcoded with values and I don't see any mentions of getting the prior months data.
When I adapt this to my data the result is empty.