Forum Discussion
Helper IVWHAT IF Analysis On Stocks
Hi,
Can some please help in sharing article, where i can understand how to use WhatIF analysis on Stocks table. Below is one example.
DateOpenHighLowClose*Adj. close**Volume
| 20-May-2020 | 1,950.00 | 1,962.90 | 1,931.70 | 1,953.60 | 1,953.60 | 27,77,614 |
| 19-May-2020 | 1,903.00 | 1,966.45 | 1,903.00 | 1,948.65 | 1,948.65 | 31,98,693 |
| 18-May-2020 | 1,907.00 | 1,952.95 | 1,872.10 | 1,945.60 | 1,945.60 | 37,27,694 |
| 15-May-2020 | 1,916.00 | 1,917.40 | 1,865.20 | 1,892.90 | 1,892.90 | 31,73,682 |
| 14-May-2020 | 1,910.00 | 1,923.10 | 1,891.10 | 1,902.35 | 1,902.35 | 22,63,146 |
| 13-May-2020 | 1,994.00 | 1,994.00 | 1,925.65 | 1,949.65 | 1,949.65 | 26,56,665 |
| 12-May-2020 | 1,933.40 | 1,956.50 | 1,910.25 | 1,949.50 | 1,949.50 | 32,56,595 |
| 11-May-2020 | 1,909.00 | 1,951.40 | 1,909.00 | 1,935.30 | 1,935.30 | 24,49,841 |
| 08-May-2020 | 1,939.10 | 1,939.50 | 1,886.25 | 1,893.40 | 1,893.40 | 26,86,530 |
| 07-May-2020 | 1,910.00 | 1,934.45 | 1,883.35 | 1,891.65 | 1,891.65 | 31,66,754 |
| 06-May-2020 | 1,939.80 | 1,953.70 | 1,893.60 | 1,903.60 | 1,903.60 | 35,17,431 |
| 05-May-2020 | 1,955.10 | 1,977.00 | 1,927.00 | 1,932.75 | 1,932.75 | 29,05,528 |
| 04-May-2020 | 1,966.00 | 1,966.00 | 1,913.65 | 1,930.45 | 1,930.45 | 37,29,348 |
| 30-Apr-2020 | 1,980.00 | 2,032.00 | 1,942.20 | 2,014.45 | 2,014.45 | 59,15,544 |
| 29-Apr-2020 | 1,874.00 | 1,912.55 | 1,850.05 | 1,905.65 | 1,905.65 | 42,41,510 |
Thanks,
K R RAO
7 Replies
- Greg_Deckler
Community Champion
What do you want to What If?- amitchandak
Super User
kolturra , In power BI whatif is refer to whatif parameter
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
Can you please explain with an example. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Please Watch/Like/Share My webinar on Time Intelligence: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
My Your Tube Tips at: https://www.youtube.com/playlist?list=PLPaNVDMhUXGYrm5rm6ME6rjzKGSvT9Jmy
Appreciate your Kudos.
kolturraHi,
By using WHATIF analysis, i want to understand how much time it will take to reach certain amount with historical stock data.
Min Value = 450
Max Value =500
Incremental = 10
By selecting these options, can i know in how time or days i will be reaching these value, my be kind of forecast option. Since, in Power BI we don't have option to forecast weekdays data. That is why i am using WHAT IF analysis to get these results
Thanks,
K R RAO
- Greg_Deckler
What do you want to What If?
