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.

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

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

    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's avatar
      VahidDM
      Icon for Super User rankSuper User
      4 years ago

      Hi admin11 

       

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

       

      Appreciate your Kudos!!

       

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

        VahidDM

         

        Here you go.