DAX make number negative

jsmooth47 · ‎09-20-2016

If an employee doesnt have a certain amount of hours worked midway through the month, management wants to be notified. Im looking for a DAX where

=IF ('hours worked')<40 by the 14th of every month, make the number -1.

Im am not great with DAX, any help.

Greg_Deckler · ‎09-20-2016

Something like this perhaps?

Lazy = IF(SUMX(FILTER(HoursWorked,HoursWorked[Day]<16),HoursWorked[Hours Worked]) < 40,-1,SUMX(HoursWorked,HoursWorked[Hours Worked]))

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources