Forum Discussion

BYENER's avatar
BYENER
Helper V
2 years ago
Solved

Use another calculation for values before a specific date

Hi All,   I hope someone can help me. I am using a measure to sum hours and divide by 8 and multiply by 7.5, but I don't want to do the last step (/8 * 7.5) for hours after 1st of January 2024. How...
Need Help
  • Fowmy's avatar
    Fowmy
    2 years ago

    BYENER 

    Try this measure:

    Bruto Hours X =
SUMX (
    Hours,
    IF (
        Hours[Datum] < DATE ( 2024, 01, 01 ),
        DIVIDE ( Hours[X], 8 ) * 7.5,
        Hours[X]
    )
)



BYENER's avatar
BYENER
Helper V
2 years ago

Fowmy  thanks a lot! It's working.