Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi community,
Last value by Year = VAR LY = CALCULATE ( LASTNONBLANK ( 'Calendar Table'[Date], [Sum Valorisation] ), FILTER ( ALL ( 'Calendar Table' ), 'Calendar Table'[Date] <= MAX ( 'Calendar Table'[Date] ) ) ) RETURN CALCULATE ( [Sum Valorisation], FILTER ( ALL ( 'Calendar Table' ), 'Calendar Table'[Date] = LY ) )
With this solution i get the last known value for each line, each year
Is it possible to obtain the grand total of the retained values per year?
As you can see below when I select more than one asset, last value per line work's fine but the grand total is false. I need it for calculating portfolio ratios.
Thanks you
Solved! Go to Solution.
Hi @nasolme ,
Please try to use SUMX function:
Measure = SUMX(VALUES('TABLE'[YEAR]),[Last value by year])
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @nasolme ,
Please try to use SUMX function:
Measure = SUMX(VALUES('TABLE'[YEAR]),[Last value by year])
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |