How to create expression for detect new product ?

[admin11]

Hi All

I got 2 fields.

- Last Sales

- Last Purchase Date

May i know how to write the expression , when :-

Last Sales = 00/00/0000 & Last Purchase Date not = 00/00/0000 is equal to new product

Hope some one can share with me.

Paul

[VahidDM]

Hi @admin11 

Try this:

Measure= if(MAX([Last Sales])<>MAX([Last Purchase Date]),"new product")

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

[admin11]

@VahidDM 

Thank you for sharing . i have try your propose code , it display Blank . Actual my condition , There is no sales for new product , Last Sales is 00/00/0000 , But There is Purchase date. As i indicate in Red below. 

Last Sales = 00/00/0000 & Last Purchase Date not = 00/00/0000 is equal to new product

[VahidDM]

Hi @admin11 

Can you share a sample of your data in the table format?

Appreciate your Kudos!!

[admin11]

@VahidDM

Here you go.

[Ashish_Mathur]

Hi,

Try this measure

=countrows(filter(values(Data[Model_invc]),[last sales]=blank()&&[last purchase date]<>blank()))

Hope this helps.

[admin11]

@Ashish_Mathur 

I still get error after modify your script.

new_pro = countrows(filter(values(data[INVC][Last Salesl=blank()&&[Purchase date]<>blank())))

[Ashish_Mathur · Accepted solution]

Hi,

This calculated column formula works

New Product_final 1 = IF(and(INVC[Last Sales]=blank(),invc[Last Purchase Date]<>blank()),"New product","Existing product")

Hope this helps.

[admin11]

@Ashish_Mathur 

Many thank , your script working fine.

Paul

[Ashish_Mathur]

You are welcome.

[VahidDM]

@admin11 
Try this measure:

Measure = IF(
    ISBLANK( MAX( [Last Sales] ) ) && NOT ISBLANK( MAX( [Last Purchase Date] ) ),
    "New Product",
    MAX( [Last Sales] )
)

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

[admin11]

@VahidDM 

I have try using column , it got error , when i try as measure , it does not able filter.

My PBI file :-

https://www.dropbox.com/s/x3w1smk5p2atfxm/PBT_V2021_118.pbix?dl=0

Paul

[VahidDM]

Hi @admin11 

Download file: https://gofile.io/d/oXT2Zu

Try this measure:

New Product =

if(max(INVC[Last Sales])=blank()&&max(INVC[Last Purchase Date])<>blank(),"New Product",max(INVC[Last Sales]))

output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!