Forum Discussion

badger007's avatar
badger007
Frequent Visitor
4 years ago
Solved

Conditional sum of a column

Hi guys, I have a table with dates and column values. Also, I have two measures: one with the third month from today, and a quantity to be applied. The goal is to apply the quantity, in this case, ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    badger007 

    could you pls provide the sample data ,not the screenshot

    maybe you can try this

    measure= if(max(month)=month(today())+2, sum(product2)+300,sum(product2))

ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

badger007 

could you pls provide the sample data ,not the screenshot

maybe you can try this

measure= if(max(month)=month(today())+2, sum(product2)+300,sum(product2))

  • badger007's avatar
    badger007
    Frequent Visitor
    4 years ago

    thanks! it solved my problem

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      4 years ago

      you are welcome