Hello Sam, I hope all is well with you.
Let me know if you can help me with a matrix that I am trying to build.
In my model there are 2 Tables: Sales and Dates
Sales from Jan 2017 to Nov 2018. So there is no data for dec 2018.
Below you will see the matrix that I am trying to build:
And below it is the one that I got with Dax basic formulas:
As you can see I do not want to consider data from December 2017.
Any help would be very appreciated.