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

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.