Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |