How to calculate in power bi ( DAX or Power query) to get selected values?

[Deeintu]

Hi every one,

I'm struck and really struggling to build a logic in power BI,  I'm looking for a solution to reslove in power query or by writing DAX.

I had massaged data and it is in good shape now.

For e.g. current month is Febrauary 2022, so in the column "Curr Forecast" the values will start showing up from the current month to future months  in the financial year i.e. from Feb 2022 to Jun 2022.

Now I need to calcualte current financial year forecast i.e. from July 2021 to June 2022.

Values that are highlighted in the above picture should show as a single column "Current FY forecast".

So the expected columns and vaues are shown in the report should be as per below screenshot:

OUTPUT:

1) Calculate "Current FY Forecast" 

2) Calculate Variance ( "Current FY Forecast"  - Actual)

Appreciate your ideas and help.

Thanks in advance 

Dee

[Greg_Deckler]

@Deeintu Fairly certain the first thing you will want to do is unpivot all of your forecasting columns.

[Deeintu · Accepted solution]

Hi @Greg_Deckler  ,

I managed to acheive it in power query.

Thanks

Dee