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

Thanks for the input! I wasn't sure if I could reference measures in measures.

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!