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 there
I need to calculate a rolling return on a weighted average return (calculated in a measure). This is in theory 'working' but the results are a bit off, almost like the rounding isnt correct.
I have applied the same formula to a column (Measure 3 below) and to the measure (with the same values - Measure 2). The productx of the the column is correct, the same formaula on the measure is not correct.
Measure 2 and 3 SHOULD be the same?
Way too much going on there to understand what exactly is happening but the column and measure would not have to return the same results as the column has row context and no filter context while the measure has only filter context. So, going to depend on a whole array of possibilities.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Thanks @Greg_Deckler , I might have been looking at this for too long and over explained!
I have simplified this and included the pbix. In short, the productx of a measure isn't generating the correct result when compared to excel, it is extreamely close which is why I think this could be a rounding issue.
https://www.dropbox.com/s/dciqrcsiu4eyvcu/fund%20analysis%20Sample.pbix?dl=0
https://www.dropbox.com/s/k4qejr511it9xnh/data6.csv?dl=0
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 |
---|---|
114 | |
105 | |
79 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |