Forum Discussion

mjpollock's avatar
mjpollock
New Member
3 years ago

Conditional formula based on certain months

Hi, I'm very new to Power BI and need help adjusting a measure. I'm working with summarized end-of-month data. So far I have this:   Net Worth = DIVIDE(     'BGLCOAF'[Reserves],     'BGLCOAF'[T...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi mjpollock ,

 

I think your code should look like as below.

Net Worth with Condition =
IF (
    'BGLCOAF'[Month] IN { "March", "July", "September", "December" },
    DIVIDE ( 'BGLCOAF'[Reserves], 'BGLCOAF'[Total Assets], 0 ),
    DIVIDE ( 'BGLCOAF'[Reserves] + [Net Income], 'BGLCOAF'[Total Assets], 0 )
)

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.