Realized data + forecast data for financial report

[dhave]

I need to create a report based on two diffrent sources : Data (turnover, charges, costs, ...) for the last months (realized since the beginning of fiscal year) from excel file, data for the next months (from this month to the end of the fiscal year).

Can you help me to build this kind of report in PowerBI Desktop ?

I don't how to proceed to build this one.

Thanks in advance

[v-caliao-msft]

@dhave,

Could you please provide us some sample data? Generally, you could create another table to reutrn all the month for this fiscal year. And then add one column to return realized data and forecast data base on current month.

Regards,

Charlie Liao