Forum Discussion
Interval Previous Date
I found the solution:
No need for involving the date table .
see attached.
Hello, I simplified my example to make it easier to understand. I will need to use the calendar table in my real model since I have other stuff I will need to show in the same matrix. Would you have any idea how to do it with the calendar table?
Thank you
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hello, it is pretty much the same file that you created with a dates and product table. Having the other tables from my real model is not necessary. I just need to be able to recreate what you did but from a dates table.
Thank you