Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Report Builder Nested If

I need to build a nested "If" Sum calculation that follows this logic: If PrevFtp2 =0 THEN 0 If CurrFtp2 =0 THEN PrevFtp2/PrevBook2 Else PrevFtp1/PrevBook1 - PrevFtp2/PrevBook2
Tips and Tricks
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    Thankyou, ajohnso2, techies, for your response.

    Hi Anonymous,

    We appreciate your inquiry posted on the Microsoft Fabric Community Forum.

    Further to the response provided by techies , please find attached the screenshot and the PBIX file, which may assist in resolving the issue:

    If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will help other community members facing similar queries.

    Thank you.

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

Hi dashmarley11,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.