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 everyone,
I'm trying to do TWRR (time-weighted return) on Power BI. Therefore, the formula consists of two steps, first the increment value of two periods (+1), and then the product value of the increment.
I did the increment measure, but I can not use a measure in the PRODUCT formula.
Do you have any idea how I can solve this?
Solved! Go to Solution.
Hi @juliliscarmo,
Maybe you can try to use below formula, I extend measure as column and add to variable table, then use this variable table and new column to calculate.
Product Increase = VAR temp = ADDCOLUMNS ( ALLSELECTED ( Table1 ), "InCrease", [increase] ) RETURN PRODUCTX ( FILTER ( temp, [ID] = MAX ( Table1[ID] ) ), 1 + [InCrease] )
Regards,
Xiaoxin Sheng
Hi @juliliscarmo,
Maybe you can try to use below formula, I extend measure as column and add to variable table, then use this variable table and new column to calculate.
Product Increase = VAR temp = ADDCOLUMNS ( ALLSELECTED ( Table1 ), "InCrease", [increase] ) RETURN PRODUCTX ( FILTER ( temp, [ID] = MAX ( Table1[ID] ) ), 1 + [InCrease] )
Regards,
Xiaoxin Sheng
Hi @juliliscarmo,
I attach it below.
Regards,
Xiaoxin Sheng
Thank you!
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |