Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi Experts
Is it possible to have 4 different what-if parameters each one works for a different year in the same sales tables.
ie.
Parameter 1 = 2023
Parameter 2 = 2024
Parameter 3 = 2025
Parameter 4 = 2026
Paramter 1 cannot impact other years on the assigned yr
Solved! Go to Solution.
@Anonymous , yes you can create 4 whatif/numeric parameters, and you can use them in measure
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
@Anonymous , yes you can create 4 whatif/numeric parameters, and you can use them in measure
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
Hi Amrik
How do you assign a paramter to the different years and that parameter only applies to that year
User | Count |
---|---|
84 | |
76 | |
74 | |
49 | |
39 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |