Forum Discussion
Conditional on matrix result sold between dates
Hi DGFranco77
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-...
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/1447523
Hi Ritaf1983
Sorry for the lack of clarity, but what I need would be to absolutely analyze all products regardless of whether they have sold or not, I know I can enable items without data. But I would like to condition them by month, as I show in the example below how I would like to see the result. Let's go, product M0537 was registered in the month of October, so the previous months of sales even though they are not in my sales table I would like to show blank because it did not exist and from October show as 0 because it came into existence, but, did not sell, I would like to know how to do this, even without the sales data in fact. The same happens for product M0539, but with some months with sales.
Remember that I have a "registration_date" field for the product in my product table and "sales_date" in the sales table, which is what goes in the matrix. Maybe I need to work with these dates together. Both tables are already related by the product_code.
Please let me know if this is clearer.
Thanks