❤ this not a learning platform This is your platform/portfolio to receive appreciation for your work😂😂😂 Impressed by your ideology (I am expecting a resume project with a forecasting or predictive kind of the also include like how to explain it to the stakeholder🎉)
Hey was looking for this thanks for sharing this ..I also want to check my what if through multiple simulations or criterias not only margin changes in cost revenue or rates etc can we also include those conditions in this model
Thanks for the comment and the support. It is possible to have multiple simulations, you can create as many parameters as needed and incorporate them into your data model appropriately.
Hi, thanks for the video. I have a challenge with What If analysis in Power BI witj my project. So, do we have any ways to use what-if in 2 directions. In the video, we did What if on Return $, that is 1 direction, now if we have a certain target to reach for Net Sale, let say 1,000,000, how it will impact against the Return $ or Return % ?
Thank you for asking this question and I'm happy to hear you enjoyed the video! This solution is designed for one specific direction. If you wanted to setup a 2 direction what-if solution I'd look into the following steps. It's a fairly complex solution but this is what I would attempt to complete. 1. Create a what-if scenario following the video 2. Create a second what-if scenario going to the inverse direction, updating the DAX where applicable 3. Create a button which toggles these visuals to show/hide 4. Stack the visuals on top of each other 5. Use the button to determine the visibility of each what-if scenario. It's a fairly complex solution but this is my first iterative idea, let me know what you decide to go with!
i have an issue, first when i set the starting 0,1,0.1 the incremental scrol bar allowed me in tens 20 30 40 like that not able to set dynamically like 31 or 47 like that so i changed to the incremental 0,1,0.01 then i can able to do it like 37,98, like that but cant able to do the % as 100 it maximum is 99 (could you help to encounter this issue)
Thanks for sharing your question! To help with troubleshooting, if you click on the table created by the new parameter, does it list all values within the range (up to 100) or does stop at 99. Also, please share the DAX code for the table above for reference, example below for code within the project. What If Returned % = GENERATESERIES(CURRENCY(0), CURRENCY(1), CURRENCY(0.01))
Hey Bro, again a very well done Video ! Thanks a lot for your effort 🙋🏼♂️👍🏻
Thank you!!
Completely usefull and thank you for sharing your knowledge and time.
Thank you for this comment and your support, my pleasure!
you really made me feel I am too bad in power bi keep going xD you are amazing
Thank you for this compliment! I certainly only want to help you feel better about Power BI, thanks for your support!!
Great content as always!
Awesome thank you!!
❤ this not a learning platform
This is your platform/portfolio to receive appreciation for your work😂😂😂
Impressed by your ideology
(I am expecting a resume project with a forecasting or predictive kind of the also include like how to explain it to the stakeholder🎉)
Thank you for sharing and I appreciate the compliment!
Hey was looking for this thanks for sharing this ..I also want to check my what if through multiple simulations or criterias not only margin changes in cost revenue or rates etc can we also include those conditions in this model
Thanks for the comment and the support. It is possible to have multiple simulations, you can create as many parameters as needed and incorporate them into your data model appropriately.
Hi, thanks for the video. I have a challenge with What If analysis in Power BI witj my project. So, do we have any ways to use what-if in 2 directions. In the video, we did What if on Return $, that is 1 direction, now if we have a certain target to reach for Net Sale, let say 1,000,000, how it will impact against the Return $ or Return % ?
Thank you for asking this question and I'm happy to hear you enjoyed the video!
This solution is designed for one specific direction. If you wanted to setup a 2 direction what-if solution I'd look into the following steps.
It's a fairly complex solution but this is what I would attempt to complete.
1. Create a what-if scenario following the video
2. Create a second what-if scenario going to the inverse direction, updating the DAX where applicable
3. Create a button which toggles these visuals to show/hide
4. Stack the visuals on top of each other
5. Use the button to determine the visibility of each what-if scenario.
It's a fairly complex solution but this is my first iterative idea, let me know what you decide to go with!
i have an issue, first when i set the starting 0,1,0.1 the incremental scrol bar allowed me in tens 20 30 40 like that not able to set dynamically like 31 or 47 like that so i changed to the incremental 0,1,0.01 then i can able to do it like 37,98, like that but cant able to do the % as 100 it maximum is 99 (could you help to encounter this issue)
Thanks for sharing your question! To help with troubleshooting, if you click on the table created by the new parameter, does it list all values within the range (up to 100) or does stop at 99.
Also, please share the DAX code for the table above for reference, example below for code within the project.
What If Returned % = GENERATESERIES(CURRENCY(0), CURRENCY(1), CURRENCY(0.01))