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,
Actually I'm trying to calculate the measure with foloowing formula but it is giving me error "The SUM function only accepts a column reference as an argument."
Fomula -
''' EXP(SUM(LN(1 + Query1[FundReturn]) * 1))'''
DAX Syntax -
Can anybody please help me in this!! Thanks
Solved! Go to Solution.
Try sumx
Expost_CumRet = CALCULATE( EXP(SUMx(Query1,LN(1 + Query1[FundReturn]) * 1)), FILTER(ALLSELECTED(Query1), Query1[Index.1]<=Max(Query1[Index.1]) )
Try sumx
Expost_CumRet = CALCULATE( EXP(SUMx(Query1,LN(1 + Query1[FundReturn]) * 1)), FILTER(ALLSELECTED(Query1), Query1[Index.1]<=Max(Query1[Index.1]) )
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |