Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
What do you want to What If?
@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-Y...
My Your Tube Tips at: https://www.youtube.com/playlist?list=PLPaNVDMhUXGYrm5rm6ME6rjzKGSvT9Jmy
Appreciate your Kudos.
Hi,
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
You can do a forecast by using the analytics tab in the visulisation pane.
The shaded line is giving me the upper and lower limit of the share open price based on confidence level I have assigned in the forecast line, you cna alos try the trend line, min and average line.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi,
Is it possible forecaset only for weekdays?
Thanks,
K R RAO
Hi @kolturra ,
Have shown the trend basis your data which are weekdays?
Not sure if you can only forecast for weekdays. No option to tell Power Bi to forecast for x days with a gap in between.
Regards,
Harsh Nathani
User | Count |
---|---|
128 | |
112 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
116 | |
102 | |
71 | |
57 |