I have a table in Power BI that has monthly cost data. Some of the products have been decommissioned or reclassified since the last invoice from finance. I currently have a column in another table that defines each of the products that flags the product as decommissioned or reclassified and when showing what the future forecast of costs might be I’m able to sort out those decommissioned or reclassified products very easily BUT, it also removes them from all previous months also. What I would like to do is add a date column to the product definition table that indicates when the reclass or decommission will occur so that the product is only remove from that month forward. What is the best way to do that?
The file coming from finance has the separate line for each product and their cost for every month. So if apples was reclassified in April and melons was decommissioned in Mar the data should look like the table. I might still have data in the sales file for these products and the months but because there is a date in the products definition table the amounts would be filtered out from the date in the table forward.
| Product | Jan | Feb | Mar | Apr |
| Apples | 100 | 127 | 175 | |
| Pears | 97 | 75 | 82 | 67 |
| Lettuce | 103 | 107 | 99 | 175 |
| Melons | 115 | 175 | | |
