Show only new items

[tep12w]

I'm trying to create a measure that shows items that have been sold this month but not in any previous months. So newly sold items only that have never appeared in previous months data. Is there a easy way to do this? Thanks

[ERD]

Hi @tep12w ,

If you need a measure, you can use the next one:

CheckNewItems =
VAR currD =
    MAX ( T[Date] )
RETURN
    IF ( CALCULATE ( COUNT ( T[Item Sold] ), T[Date] <= currD ) = 1, 1)

Then you can use it to filter the visual

Or, supposing you have a proper Calendar table connected with your Data table. Then you can use the next measure:

CheckNewItems_2 =
VAR currItem = MAX ( T[Item Sold] )
VAR firstMonthSold =
    CALCULATE (
        MIN ( 'Calendar'[Month num] ),
        FILTER ( ALL ( T ), T[Item Sold] = currItem )
    )
RETURN
    IF ( MAX ( 'Calendar'[Month num] ) = firstMonthSold, 1 )

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

[Anonymous]

Hello @tep12w 
You can try a calculated column. Please note the date is a must for this calculation and I'm assuming you have dates for items sold.

Result =

VAR FirstMonth =

CALCULATE (

MIN ( 'New Items'[Date] ),

FILTER (

ALL ( 'New Items' ),

'New Items'[Item Sold] = EARLIER ( 'New Items'[Item Sold] )

)

)

RETURN

IF ( 'New Items'[Date] = FirstMonth, 'New Items'[Item Sold] )

[Anonymous]

Hello @tep12w 
You can apply the condition where the date is in this current month.
If you need more help please share your data in table format with the expected output after removing sensitive data.

[tep12w]

Thanks. I have included a simplified table below. I want to be able to select the month of June and have the chart only show 'Draws' because 'Chair' and 'Lamp' had already been seen before, in May. For the month of June the item 'Draws' has never been seen before. That's all I want to see in the graph. Hope that makes sense?

Date	Item Sold
May	Chair
May	Lamp
May	Bulb
June	Chair
June	Lamp
June	Draws