Forum Discussion

SPDA's avatar
SPDA
Regular Visitor
1 year ago
Solved

Help with adding if then statement?

Hello,   I am new to creating measures and have hit a wall. Can anyone help? I've created a measure that works properly to calculate the sum of a field called AgrHrsCovered for Jan 2025 only. I...
Need Help
  • wardy912's avatar
    wardy912
    1 year ago

    Can you provide a sample of the data please? It may be better to use a calculated column that only performs the if statement, depending on how your data is presented

    Here i've used the column
    CalculatedColumn = IF('January2025Hours'[Hours] < 1, 1, 'January2025Hours'[Hours])

     

    to obtain the following results

     

    Let me know if this fixes the issue, thanks

SPDA's avatar
SPDA
Regular Visitor
1 year ago

Hey, thanks, wardy912. That looks like it makes sense to me, but when I compared the new (TEST Jan 2025 Hrs)  to the original (Jan 2024 Hrs) it isn't doing what I want:

 

wardy912's avatar
wardy912
Super User
1 year ago

Can you provide a sample of the data please? It may be better to use a calculated column that only performs the if statement, depending on how your data is presented

Here i've used the column
CalculatedColumn = IF('January2025Hours'[Hours] < 1, 1, 'January2025Hours'[Hours])

 

to obtain the following results

 

Let me know if this fixes the issue, thanks