Forum Discussion
Table to Filter Out Items Without Transactions
The goal is to have a table which will remove items that have not had transactions over 3 weeks. Currently, I have a table which highlights weekly transactions of items >>> Current week vs. Previous ...
Anonymous , create a measure for 3 weeks and use that in visual level flter check >0 and noy is blank
Rolling 3 week = CALCULATE(sum(Table[Transaction_Count]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-21,Day))
in visual lvele filter check Rolling 3 week >0 and Rolling 3 week is not blank
Anonymous , create a measure for 3 weeks and use that in visual level flter check >0 and noy is blank
Rolling 3 week = CALCULATE(sum(Table[Transaction_Count]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-21,Day))
in visual lvele filter check Rolling 3 week >0 and Rolling 3 week is not blank
amitchandak thank you so much for your support! This worked great! So much gratitude!