Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all, I am trying to create a column using DAX to calculate the cumulative return of the fund and BM column, can you please help? Thanks in advance!
Solved! Go to Solution.
@andyly85 Try:
Column =
VAR __Date = [Date]
VAR __Result = SUMX( FILTER( 'Table', [Date] <= __Date ), [Fund] )
RETURN
__Result
@andyly85 Try:
Column =
VAR __Date = [Date]
VAR __Result = SUMX( FILTER( 'Table', [Date] <= __Date ), [Fund] )
RETURN
__Result
User | Count |
---|---|
57 | |
21 | |
21 | |
19 | |
16 |
User | Count |
---|---|
85 | |
80 | |
52 | |
37 | |
22 |