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 ...
Need Help
  • Joshua_'s avatar
    Joshua_
    7 years ago

    SOMETHING LIKE THAT

     

  • 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.

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.

  • Joshua_'s avatar
    Joshua_
    Helper II
    7 years ago

    It Worked.

     

    Thank Amy

    Regards,