filtered values
2 Topics
show values in data table filtered under different conditions
Hello all, I need help with DAX code that would produce results in a matrix table under the following conditions. So far not much luck.. Conditions For example, i have the following data with items under "Inventory", "Shipped", and "Invoiced" column. The actual table consists of thousands of rows, and the items in "Inventory", "Shipped" are not unique. They can consist of same/similar items. The requirement 1) Filter "Invoiced" column as "No". (this will determine the "Inventory" items) 2) Based on the Inventory items in 1), I need all of the "Shipped" items for each Inventory item, if the "Invoiced" condition is set to "Yes". *In the actual data, per each "Inventory" item, it will usually consist of 1 or more "Shipped" items. Inventory Shipped Invoiced A Z Yes B Y No C X Yes A W No B V Yes C U Yes A T No B S Yes C R No A Q Yes ・ ・ ・ ・ ・ ・ Thank you in advance!Solved1.2KViews0likes4Comments
get minimum of selected slicer column values, in a table showing the selected column.
slicer: yearmonth selected: 2023-09 and 2023-10 table yearmonth | salesvalue 2023-09 | 1234 2023-10 | 4321 what I want to add is the accumulated sales in the selected period. table yearmonth | accum.sales 2023-09 | 1234 2023-10 | 5555 for this I need the minimum and maximum of the selected slicer values, to get the filter in dax: yearmonth >= MinYearMonth, yearmonth <= MaxYearMonth. How to get the Min and MaxYearMonth? Because in the table itself the selectedvalue of yearmonth becomes the single value of the line in the table: either 2023-09 of 2023-10, not both. Thanks!Solved1.3KViews0likes2Comments