Forecast

[Anonymous]

Hello All,

Please help me with the Forest Revenue projection in Power BI. Attached Excel for your reference and please help me with the same.

1. In the above Table Apr'19 and May'19 are actuals Revenue and from June it is a Forecast Revenue
2. Final Projectected Revenue =( Revenue+Expected Revenue+Forecast Revenue)
3. Revenue from June is carred from May and formula is Revenue Jun'19=(final projected Revenue-Expected Revenue)
4. Expected Revenue and Revenue should be projected from Jun'19 to Mar'20.
5. Need the same in Power BI

Please let me know for further details

https://drive.google.com/file/d/1xT8HhU0ThOMXRNOSp6ZGemWt2Q7AuUgT/view?usp=sharing

REgards,

[v-yulgu-msft]

Hi @Anonymous ,

To make the requirement more clear, please show us the data structure in source table and the desired resultbased on source table.

How to Get Your Question Answered Quickly

Best regards,

Yuliana Gu

[Anonymous]

https://drive.google.com/file/d/1mrpN83sf99TKIm9_ecCaEdzmb6Wl2kFo/view?usp=sharing

Hello All,

Please suggest if this formula highligted in Excel is possible in Power BI.

Appreciate your help.

Regards.

[Anonymous]

Hi,

We are tracking the forecast in Excel, hence we dont have multiple files from where the figures were tracked.

In brief, from Table1, I've the actual figures tracked in Excel. 

As per the Logical understanding "Expected Revenue" is the kind of recurring business and expected to receive every month. Example in the below table May'19 Revenue is $6,200 and expected to receive this revenue till the end of Mar'20, hence, forecasted till Mar'20 and in forecast Table, if the revenue realised is $ 6500 from July it should reflect as 6500 till Mar'20. Hence, the revenue should roll till the end of Financial Year.

Table1

Forecast File

Please help me if you need further details

REgards.

[Anonymous]

Hi All,

Please help me with a solution. Let me know if you any details.

Appriciate you help...