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

mfed's avatar
mfed
Frequent Visitor
1 year ago

Yes, for sure - in fact in my training it was best practice to create a 'Measure Table' with as many measures as you thought you might need, then you can reference them on their own or in other measures. It's a standalone table in the data model with all your individual measures, and once you have that it sits right at the top of your 'Data' section on your main screen.

SPDA's avatar
SPDA
Regular Visitor
1 year ago

Nice, I'll add that to my practice. Appreciate the tip!