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.

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

Hi,

Try this measure

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

Hope this helps.

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

    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's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      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

        Ashish_Mathur 

        Many thank , your script working fine.

        Paul