Forum Discussion

Mk2018's avatar
Mk2018
Frequent Visitor
8 years ago
Solved

DAX IF Calculation error

Hi,    I have been using the 'IF' calculation for a report i am working on. The calculation is using categorising time values into a time period.    For example,   IF('_____________'[_______]}>...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Replace the < with <= or if you want to keep the < change the comparison value:

     

    IF('_____________'[_______]}>("00:00:00") && [_______] <= ("00:04:59"),("< 5 mins)

     

    IF('_____________'[_______]}>("00:00:00") && [_______] < ("00:05:00"),("< 5 mins)

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Replace the < with <= or if you want to keep the < change the comparison value:

 

IF('_____________'[_______]}>("00:00:00") && [_______] <= ("00:04:59"),("< 5 mins)

 

IF('_____________'[_______]}>("00:00:00") && [_______] < ("00:05:00"),("< 5 mins)

Mk2018's avatar
Mk2018
Frequent Visitor
8 years ago

IF('_____________'[_______]}>("00:00:00") && [_______] <= ("00:04:59"),("< 5 mins)

 

this worked!! :) thank you for your help