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

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
1 year ago

Thank you, wardy912, mfed, for your response.

Hi SPDA,

We appreciate your inquiry raised through the Microsoft Fabric Community Forum.

Based on my understanding of the issue, please find attached a screenshot along with a sample PBIX file, which may assist in resolving the problem:

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will help other community members who may have similar queries. However, if the response does not address your requirements, please provide sample data that clearly illustrates your issue or question in a usable format (and not as a screenshot). Kindly ensure that the data shared does not contain any sensitive or unrelated information. Additionally, please indicate the expected outcome based on the sample data provided.

Should you have any further questions or concerns, please feel free to reach out to the Microsoft Fabric Community.

Thank you.