Forum Discussion
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
Thankyou, ajohnso2, techies, for your response.
Hi dashmarley11,
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.
if(PrevFtp2 = 0, 0, if(CurrFtp2 = 0, PrevFtp2/PrevBook2, PrevFtp1/PrevBook1 - PrevFtp2/PrevBook2))