Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have this :
I have in a field parameter 4 opties connected to 4 different measures.
So when I change selection from Addendum to Inbound the amounts under addendum will change to the inbound amounts.
Perfect.
But for my selection I also want to get the amounts of sameperiodlastyear. (and then subtract but that would not be the hardest part).
In my calculate I cannot get the reference to prmLBE_Comp apparently.
How would I reference the selected measure from my field parameter in my calculate?
Solved! Go to Solution.
Hi @rpinxt ,
I made simple samples and you can check the results below:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @rpinxt ,
I made simple samples and you can check the results below:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
thanks @v-tianyich-msft seems to be working in your example. Will have a look if I can implement it in my file.
Tried something now with using a switch:
I am not getting any errors but the result is not sameperiodlastyear but the same amount as the current year.....
Makes no sense to me. Guess the option with switch is also not the way to go.
User | Count |
---|---|
97 | |
88 | |
76 | |
70 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |