Forum Discussion
Solved
Ignoring filters on text columns
Hi, I have created a stock movements report, there are measures for Opening, closing and different types of movements in a selected period using a date slicer (based on the posting date of the st...
I managed to get this working but by making changes to the dataset in power query.
I created a new table with all of the item numbers and merged with a table with all month ends in. Then appended to the stock movement tables.
Then created a new measure to filter out the records that had no open/closing/movements within the selected range
I managed to get this working but by making changes to the dataset in power query.
I created a new table with all of the item numbers and merged with a table with all month ends in. Then appended to the stock movement tables.
Then created a new measure to filter out the records that had no open/closing/movements within the selected range