If logic with set analysis help

[pawwy1415]

Hi Everyone,

Can any one please help me on below requirement.

I have a Dimension called Month and  Two measures like Estimates and Actuals

Estimates:

Sum({$<Year ={'$(=Year(Max([Reporting Date])))'},[Type]={'Estimates'},Month,MonthYear=>}[Amount])/1000000

Actuals:

Sum({$<Year ={'$(=Year(Max([Reporting Date])))'},[Type]={'Income'},Month,MonthYear=>}[Amount])/1000000

Requirement:

I have to derive a Third measure like

when previous month have the actual then need to Apply Estimate -Actual 

when previous month don't have the actual then need to apply Estimate-Estimate.

Please find the below Expected output. Please help me on this.

Thanks in advance.

[Shubham_Deshmukh]

Hi,

Hope you will get it from this,

=if(above([act])<>0,[est]-RangeSum(above([act]),0),[est]-above([est]))

Do testing with more data and let me know.

Regards,

Shubham