Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 week. There can be items which will have no transactions. Problem is that there are hundreds of items and my current table can have an vast amount of items that have not recorded any transactions. Although my current output provides all of the information needed, visually it is not appealing with so many items/rows reflected without any transactions. I am aware that I can filter the rows to reflect Transaction_Count > 0. But not sure how to put another condition that flags 0 transactions over 3 weeks.

 

Is it possible to filter out items (and/or rows) which have not recorded any transactions over 3 weeks ? Your advice is greatly appreciated. 

 

Current Output: Please note Item_Code: A1 / A5 >>> A1 + A5 have not recorded any transactions over the past 3 weeks. 

Item_CodeFiscal_Week_YearFW_StartOfWeekTransaction_CountPrev_Week_Count
A1FW16-2022Monday, December 13, 202100
A2FW16-2022Monday, December 13, 2021012
A3FW16-2022Monday, December 13, 2021500
A4FW16-2022Monday, December 13, 2021312
A5FW16-2022Monday, December 13, 202100
A1FW15-2022Monday, December 06, 202100
A2FW15-2022Monday, December 06, 2021123
A3FW15-2022Monday, December 06, 202100
A4FW15-2022Monday, December 06, 2021120
A5FW15-2022Monday, December 06, 202100
A1FW14-2022Monday, November 29, 202100
A2FW14-2022Monday, November 29, 2021311
A3FW14-2022Monday, November 29, 202109
A4FW14-2022Monday, November 29, 2021021
A5FW14-2022Monday, November 29, 202101

Expected Output: Please note Item_Code: A1 / A5 >>> A1 + A5 have been removed because there no transactions recorded. 

Item_CodeFiscal_Week_YearFW_StartOfWeekTransaction_CountPrev_Week_Count
A2FW16-2022Monday, December 13, 2021012
A3FW16-2022Monday, December 13, 2021500
A4FW16-2022Monday, December 13, 2021312
A2FW15-2022Monday, December 06, 2021123
A3FW15-2022Monday, December 06, 202100
A4FW15-2022Monday, December 06, 2021120
A2FW14-2022Monday, November 29, 2021311
A3FW14-2022Monday, November 29, 202109
A4FW14-2022Monday, November 29, 2021021
A5FW14-2022Monday, November 29, 202101
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      amitchandak thank you so much for your support! This worked great! So much gratitude!