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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hi,
This is the original DAX formula but it needs to be changed.
Variance = AVERAGE('Census by Payer Consolidated Campus'[Daily Census]) - MAX('Census by Payer Consolidated Campus'[Month Budget])
We can't use what is highlihted in red. It would be a measure called [ADC]
The client wants the month budget column subtracted from the ADC measure. Can someone provide a DAX formula that can do this.
Thanks,
Rochelle
Solved! Go to Solution.
Hey @robarbie ,
can you create a measure called Variance like so:
Variance = [ADC] - MAX('Census by Payer Consolidated Campus'[Month Budget])
If this is not what you are looking for, provide more context. Consider creating a pbix that contains sample data but still reflects your data model. Upload the pbix to onedrive or dropbox and share the link.
Regards,
Tom
Hey @robarbie ,
can you create a measure called Variance like so:
Variance = [ADC] - MAX('Census by Payer Consolidated Campus'[Month Budget])
If this is not what you are looking for, provide more context. Consider creating a pbix that contains sample data but still reflects your data model. Upload the pbix to onedrive or dropbox and share the link.
Regards,
Tom
Hi Tom,
Yes, I can create a formula like this. But the client wants it reversed where the budget is first and then ADC. Thanks!
Actually my boss decided this will work. Thanks!
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.