Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |