Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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_Code | Fiscal_Week_Year | FW_StartOfWeek | Transaction_Count | Prev_Week_Count |
A1 | FW16-2022 | Monday, December 13, 2021 | 0 | 0 |
A2 | FW16-2022 | Monday, December 13, 2021 | 0 | 12 |
A3 | FW16-2022 | Monday, December 13, 2021 | 50 | 0 |
A4 | FW16-2022 | Monday, December 13, 2021 | 3 | 12 |
A5 | FW16-2022 | Monday, December 13, 2021 | 0 | 0 |
A1 | FW15-2022 | Monday, December 06, 2021 | 0 | 0 |
A2 | FW15-2022 | Monday, December 06, 2021 | 12 | 3 |
A3 | FW15-2022 | Monday, December 06, 2021 | 0 | 0 |
A4 | FW15-2022 | Monday, December 06, 2021 | 12 | 0 |
A5 | FW15-2022 | Monday, December 06, 2021 | 0 | 0 |
A1 | FW14-2022 | Monday, November 29, 2021 | 0 | 0 |
A2 | FW14-2022 | Monday, November 29, 2021 | 3 | 11 |
A3 | FW14-2022 | Monday, November 29, 2021 | 0 | 9 |
A4 | FW14-2022 | Monday, November 29, 2021 | 0 | 21 |
A5 | FW14-2022 | Monday, November 29, 2021 | 0 | 1 |
Expected Output: Please note Item_Code: A1 / A5 >>> A1 + A5 have been removed because there no transactions recorded.
Item_Code | Fiscal_Week_Year | FW_StartOfWeek | Transaction_Count | Prev_Week_Count |
A2 | FW16-2022 | Monday, December 13, 2021 | 0 | 12 |
A3 | FW16-2022 | Monday, December 13, 2021 | 50 | 0 |
A4 | FW16-2022 | Monday, December 13, 2021 | 3 | 12 |
A2 | FW15-2022 | Monday, December 06, 2021 | 12 | 3 |
A3 | FW15-2022 | Monday, December 06, 2021 | 0 | 0 |
A4 | FW15-2022 | Monday, December 06, 2021 | 12 | 0 |
A2 | FW14-2022 | Monday, November 29, 2021 | 3 | 11 |
A3 | FW14-2022 | Monday, November 29, 2021 | 0 | 9 |
A4 | FW14-2022 | Monday, November 29, 2021 | 0 | 21 |
A5 | FW14-2022 | Monday, November 29, 2021 | 0 | 1 |
Solved! Go to Solution.
@win_anthony , 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
@win_anthony , 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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
69 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |