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.
Hello,
We use an array formula to calculate returns in Excel. Please see details below.
How cna this be replicated in Power BI?
Thanks,
Dan
Solved! Go to Solution.
@dancarr22,
Firstly, create a column in your table.
return2 = 1+Table1[Returns(%)]/100
secondly, create a measure using DAX below in your table.
Measure = VAR DATECOL= MAX(Table1[Date]) RETURN (CALCULATE( PRODUCT( Table1[return2] ), FILTER( Table1, Table1[Date]<=DATECOL ) )-1)*100
Regards,
Lydia
@dancarr22,
Firstly, create a column in your table.
return2 = 1+Table1[Returns(%)]/100
secondly, create a measure using DAX below in your table.
Measure = VAR DATECOL= MAX(Table1[Date]) RETURN (CALCULATE( PRODUCT( Table1[return2] ), FILTER( Table1, Table1[Date]<=DATECOL ) )-1)*100
Regards,
Lydia
This worked! Thanks Lydia!
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |