Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago
Solved

How to create expression for detect new product ?

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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    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's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago

VahidDM

 

Here you go.

 

 

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

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!!

 

    • VahidDM's avatar
      VahidDM
      Icon for Super User rankSuper User
      4 years ago

      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!!