Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
I have a new measure that gives the wrong total.
New Measure =IF(ISBLANK([Forecast]), [Actual], [Forecast])
But the total of the New Measure is giving only the last month (12, August).
how can I get the correct total?
I can't provide the data because it is connected to a model.
Solved! Go to Solution.
Hi @sabd80
first we need to understand is that it is not giving you last month august total it is giving you total of [Forecast], because in that context the [Forecast] is not blank and as per your measure's IF condition we're getting that value of Forecast Total. To resolve this issue you can use this modified version of your code
New Measure=
If this helps do give a thumbs up and accep this as a solution
BR
Dark
Hi @sabd80
first we need to understand is that it is not giving you last month august total it is giving you total of [Forecast], because in that context the [Forecast] is not blank and as per your measure's IF condition we're getting that value of Forecast Total. To resolve this issue you can use this modified version of your code
New Measure=
If this helps do give a thumbs up and accep this as a solution
BR
Dark
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
75 | |
74 | |
56 | |
45 |
User | Count |
---|---|
117 | |
105 | |
77 | |
66 | |
64 |