Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I'm looking for a solution that calculate the difference between my start value and the target value in the final period:
Target | value |
A | 1200 |
year | Forecast |
2020 | 1100 |
2021 | 100 |
2022 | 900 |
In this example I expect that answer will be 300 (1200 as target minus 900 of the final year)
Not sure how to deal with this, could be simple but not for me! Thanks in advance for a reply.
Regards, Joep
Solved! Go to Solution.
@joep78
Create a measure as follows:
M =
var __year = CALCULATE( max(table[year]) , all(table])) return
var __lastvalue = CALCULATE( sum(table[forecast]), table[year] = __year )
return
max(target[value]) - __lastvalue
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@joep78
Create a measure as follows:
M =
var __year = CALCULATE( max(table[year]) , all(table])) return
var __lastvalue = CALCULATE( sum(table[forecast]), table[year] = __year )
return
max(target[value]) - __lastvalue
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi Fowmy,
Thanks for this solution, this is really helpful!
Regards,
Joep
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |