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, ...
  • ryan_mayu's avatar
    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))