Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts,
As per title, the excel formula for calculate (-5.85) from above 3 cells (-7.43, -4.69 -5.39) was below:
=GEOMEAN(1+(AP36:AR36)/100)-1)*100
I've try to convert in calculated column in below but fail :
******
Thanks a lot.
@TWMY1014 Maybe try:
test =
var MinYear = '**DM-RealEstatePriceIndicator**'[Year]
var MaxYear = MinYear+2
var Types = DISTINCT('**DM-RealEstatePriceIndicator**'[Type])
var Cities = DISTINCT('**DM-RealEstatePriceIndicator**'[CITY])
var Table = FILTER(ALL('**DM-RealEstatePriceIndicator**'), AND('**DM-RealEstatePriceIndicator**'[Year]>=MinYear,'**DM-RealEstatePriceIndicator**'[Year]<=MaxYear) && '**DM-RealEstatePriceIndicator**'[CITY] IN Cities && '**DM-RealEstatePriceIndicator**'[Type] IN Types)
return
GEOMEANX(__Table,[Value])
Hi Greg,
Thanks a lot for your prompt response.
However, it still shows 0.
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |