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 have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.