Forum Discussion

Joshua_'s avatar
Joshua_
Helper II
7 years ago
Solved

IF STATMENT

Dear,

 

I need to SUM values ​​from a table (Measure1) when the date is <= "2019-07-31".
If it is greater than "2019-08-01" I must add another measure (Measure2)

IF (@DATE <= '2019-07-31') THEN
BEGIN
      SELECT SUM(VALUE1) FROM TABLA1
END
ELSE
BEGIN
       SELECT SUM(VALUE2) FROM TABLA2
END

 

THANK A LOT

Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Joshua_ ,

     

    You may create measure like DAX below.

     

    Measure1 = IF(MAX(Table[DateKey])<=DATE(2019,7,31),SUM(Ventas[VALORA]),SUM(Detalle_Venta[MONTO]))

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi Joshua_ ,

     

    You may create measure like DAX below.

     

    Measure1 = IF(MAX(Table[DateKey])<=DATE(2019,7,31),SUM(Ventas[VALORA]),SUM(Detalle_Venta[MONTO]))

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.