Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there,
I've been struggling to figure out why I'm having problems on my calculations for a P&L report.
When I have only 2016 on my matrix the totals (sum of transactions) are correct but when I add other years to the analysis, 2016 shows up with 0.00 and the other years have the right total value. Does anyone have an idea why this is happening?
Thanks a lot in advance!
Hi @marianamarques,
From current description, I cannot imaging how you created the report and cannot reprodue your scenario. To help us better understand your scenario and requirement, please post sample data and screenshots of current result and expected result.
You can refer to this blog.
Best regards,
Yuliana Gu