topic Re: Show only new items in DAX Commands and Tips

Show only new items

tep12w — Mon, 21 Jun 2021 10:21:47 GMT

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

Re: Show only new items

Anonymous — Mon, 21 Jun 2021 10:30:36 GMT

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.

Re: Show only new items

tep12w — Mon, 21 Jun 2021 11:51:26 GMT

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

Re: Show only new items

Anonymous — Tue, 22 Jun 2021 05:10:36 GMT

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] )

Re: Show only new items

ERD — Tue, 22 Jun 2021 09:59:15 GMT

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.