Flag for new item or not new item based on months since first sale

[jpt1228]

Hello, I am working on a model and I need to report on items that have launched in the first 6 months VS items that have launched before the last 6 months.

I think the best way is going to be to write an IF statement and return "Y" for an item that has the first sale in the last 6 months from today, and a "N" for any item that launched before that.

New Item Flag = IF('ProductDIM',[ITEM] first invoice date is <6 months from today then "Y", Else "N") I know this isn't the correct way to write it but what I am trying to accomplish. Then I can bring this measure in to use as a filter for new items VS not new items.

I have a date table, invoice table, product table which are connected.

[v-chuncz-msft]

@jpt1228,

You may try to use FIRSTNONBLANK Function.