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 @v-piga-msft
I have solved the problem, but I do nor really understand why it works.
Instead of calculating the TWR as : TWR = productx(tabel1;TWR demin / yield-1) it function when im writing TWR =productx(VALUES(tabel1[date]; tabel1[TWR/yield-1])-1)
As you can see, the yellow highligthed TEST TWR is exactly the number for TWR for the portfolio in highligthed with orange in the original post.
But instead of using TWR =productx(VALUES(tabel1[date]; tabel1[TWR/yield-1])-1) I ended up using:
Hi @Anonymous ,
I have a little confused about your scenario.
Is the orange table your desired output?
In addition, is the grey table and the blue one your data sample? Are they in the same table or the different table?
If it is convenient, could you share your data sample as table format which can reproduce your scenario and your desired output so that I could have a test on it?
If I understand your situation correctly that you said the TWR is incorrect in Power BI, but the TWR demon/yeild is correct?
Best Regards,
Cherry
Hi @v-piga-msft
I have solved the problem, but I do nor really understand why it works.
Instead of calculating the TWR as : TWR = productx(tabel1;TWR demin / yield-1) it function when im writing TWR =productx(VALUES(tabel1[date]; tabel1[TWR/yield-1])-1)
As you can see, the yellow highligthed TEST TWR is exactly the number for TWR for the portfolio in highligthed with orange in the original post.
But instead of using TWR =productx(VALUES(tabel1[date]; tabel1[TWR/yield-1])-1) I ended up using:
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |