Forum Discussion
Simulate multi-month pay raises
- Anonymous2 years ago
Hi, Syndicate_Admin
Based on your description, I have created the following parameter and measure:
I created this table using the following DAX expression:
Table = UNION ( ROW ( "MonthNro", [MesNro1 Value], "Percent", FORMAT ( [Percentage1 Value], "0.00%" ), "Value", [ValorAum1] ), ROW ( "MonthNro", [MesNro2 Value], "Percent", FORMAT ( [Percentage2 Value], "0.00%" ), "Value", [ValorAum2] ), ROW ( "MonthNro", [MesNro3 Value], "Percent", FORMAT ( [Percentage3 Value], "0.00%" ), "Value", [ValorAum3] ) )Here are the results:
I've provided the PBIX file for this time below, and it would be great if I could help you.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Syndicate_Admin
Based on your description, I have created the following parameter and measure:
I created this table using the following DAX expression:
Table =
UNION (
ROW (
"MonthNro", [MesNro1 Value],
"Percent", FORMAT ( [Percentage1 Value], "0.00%" ),
"Value", [ValorAum1]
),
ROW (
"MonthNro", [MesNro2 Value],
"Percent", FORMAT ( [Percentage2 Value], "0.00%" ),
"Value", [ValorAum2]
),
ROW (
"MonthNro", [MesNro3 Value],
"Percent", FORMAT ( [Percentage3 Value], "0.00%" ),
"Value", [ValorAum3]
)
)
Here are the results:
I've provided the PBIX file for this time below, and it would be great if I could help you.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It's very close. All that remains is for the value of the parameter to be modifiable on a per-screen basis.
Thank you!