New Items Based on the sales of last Six Months

[saron]

 this is my sample table which i used in power bi. the yellow highlighted column is the one i want to create.
now i am trying to create new calculated column in power bi if the item_code is newSKU or not based on the MonthKey.
For example, in CurrentMonth, item_code '33' is in Jun-23 MonthKey and not present in the last six months so it can say Yes as newSKU 
but for item_code '22' it present in both Jun-22 and May-22 that mean it present in both current month and also in the last six months so it is No in newSKU.

any suggestion on how to get that in DAX functions on that? Thanks in advance.

[Ashish_Mathur · Accepted solution]

Hi,

Write this calculated column formula

newSKU = if(Data[isCurrentMonth]="Yes",if(CALCULATE(COUNTA(Data[Item_Code]),FILTER(Data,Data[Item_Code]=EARLIER(Data[Item_Code])&&Data[MonthKey]>=EDATE(EARLIER(Data[MonthKey]),-6)))>1,"No","Yes"))

Hope this helps.

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...