Forum Discussion

imlaug's avatar
imlaug
Frequent Visitor
6 years ago

SQL - removing data

Hi all,   I have this SQL shown below. Only problem is that there is a problem with 2 of the days with 2 specific style.   Is there a way to remove style numbers 12170151 and 12138940 for the day...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Create measure 

New measure=if(max(Table[datecolumn]) in {"23-12-2019","24-12-2019"} && table[style Number] in {12170151,12138940},1,-1)

 

then add this measure to visual level filter and set it to 1.

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

  • imlaug's avatar
    imlaug
    Frequent Visitor
    6 years ago

    Hi Pravin Wattamwar,

     

    Thank you for your response, however the struggle isnt to create a measure or an extra column, but to do it via the SQL.

     

    The issue is that i would prefer to have it removed via the SQL, as the SQL is used multiple places.

    By doing that i can avoid having to create a measure in every report.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      So you need SQL of this?

       

      simply update where clause 

      where style_number not in (Value1,value2)

      and date not in ("value1","value2")

       

      Thanks & regards,
      Pravin Wattamwar
      www.linkedin.com/in/pravin-p-wattamwar

      If I resolve your problem Mark it as a solution and give kudos.

       

      • imlaug's avatar
        imlaug
        Frequent Visitor
        6 years ago

        But wouldnt that remove the 2 days completely?

         

        I only need to remove the figures for those 2 styles on those 2 days. i still want all other data from those 2 days.

         

        Does it make sense?