IF STATMENT

[Joshua_]

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

[Joshua_ · Accepted solution]

SOMETHING LIKE THAT

[v-xicai · Accepted solution]

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_]

It Worked.

Thank Amy

Regards,

[Joshua_ · Accepted solution]

SOMETHING LIKE THAT