If Actual value is null then need to sum forecast values for that month to till the fiscalyear end.

[hari_bi]

How to replicate the above formula in Dax.

I tried like this 

"Var Forecast total = Sumx([Table], ISBLANK([Actual]),'Date'[FiscalMonth]]

IF(ISBLANK([Actual]),[Forecast total],BLANK())

but i am not able to get the excepted results.

Can any one provide me the Dax query for the abouve casestudy.

[Anonymous]

Hi @hari_bi,

Please share more details informations to help us test and coding formula. Maybe you can try to use below measure if it works on your side:

Measure =
VAR currdate =
    MAX ( Tabl[Date] )
RETURN
    IF (
        SELECTEDVALUE ( Table[Actual] ) = BLANK (),
        CALCULATE (
            SUM ( Table[Forecasts] ),
            FILTER (
                ALLSELECTED ( Table ),
                [Date] >= DATE ( YEAR ( currDate ), MONTH ( currDate ), 1 )
                    && [Date]
                        <= DATE ( YEAR ( currDate ), MONTH ( currDate ) + 1, 1 )
                            - 1
            )
        ),
        BLANK ()
    )

Regards,
Xiaoxin Sheng

[hari_bi]

Hi Xiaoxin Sheng,

Thank you for your replay.

Here i am sharing my PBI report with you and please find the Actual Vs Forecast page , exactly my requirment is available in Table visual.

IF Actual = null , i need to sum the forecast values from that perticular month to till end of that year.

https://drive.google.com/file/d/1ktOVLG7FzQbsnsX7h9GgZZ4qHcbioFZW/view

Thank you in Advance.

Regards,

Hari.

[hari_bi]

https://drive.google.com/drive/my-drive

[Anonymous]

Hi @hari_bi,

The link you share seems still in private so I can't get it.

Regards,
Xiaoxin Sheng