Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
HI!
I'm trying to rewrite the next formula in order to be able to SUM the totals of the different KPIS of my table, not to retrieve the last value.
*** I do need to retrieve the value for the last date of each year cause otherwise, I'll have duplicates. But in the end, I want the total to sum the result of each year:
Here is an example of how I calculate the Tier 1:
Solved! Go to Solution.
@a-santiago , checkout closingbalanceyear and lastnonblankvalue
Power BI closingbalancemonth closingbalancequarter closingbalanceyear, lastnonblankvalue- Closing Balance, Distribute Target: https://youtu.be/yPQ9UV37LOU
or
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
@a-santiago , checkout closingbalanceyear and lastnonblankvalue
Power BI closingbalancemonth closingbalancequarter closingbalanceyear, lastnonblankvalue- Closing Balance, Distribute Target: https://youtu.be/yPQ9UV37LOU
or
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |