Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello,
I have a paginated report expression =Last(Fields!TIME_WORKED_HOURS.Value). It works fine except for when the most recent month in the time parameters has a Null Value. For instance, if I run the report for December 2022 - February 2023 and the last month with any values is December, in the MTD column I received the December value instead of 0. How do I rewrite the expression to the February amount instead of December.
TIA!
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 7 | |
| 2 | |
| 2 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 14 | |
| 6 | |
| 3 | |
| 3 | |
| 2 |