Forum Discussion
dpombal
Post Partisan
Post PartisanDAX get count from previous existing day
I have following dataset Date ProductID 01/01/2017 1 01/01/2017 2 01/01/2017 3 02/01/2017 1 02/01/2017 2 02/01/2017 3 02/01/2017 4 05/01/2017 1 05/01/2017 ...
dpombalPost Partisan
Post PartisanI added a new column to simulate my case, i need new colum work with an slicer (PruductType)
| Date | ProductID | ProductType |
| 01/01/2017 | 1 | small |
| 01/01/2017 | 2 | small |
| 01/01/2017 | 3 | big |
| 02/01/2017 | 1 | small |
| 02/01/2017 | 2 | small |
| 02/01/2017 | 3 | big |
| 02/01/2017 | 4 | big |
| 05/01/2017 | 1 | small |
| 05/01/2017 | 2 | small |
| 05/01/2017 | 3 | big |
| 05/01/2017 | 4 | big |
| 05/01/2017 | 5 | big |
| 06/01/2017 | 1 | small |
| 06/01/2017 | 2 | small |
| 06/01/2017 | 3 | big |
| 06/01/2017 | 4 | big |
New PBIX link with new data