How to use if statement to test column values with measure

[roma]

Hello Everyone,

I have a month column which has values Jan-Dec. I have 2 measure from which I get startmonth & endmonth from slicer

Now I have to write a measure to compare months values with selectedvalue of month. The condition is 

IF sum([Actual Cases]) > 0 then sum([Actual Cases])
elseif attr([Month]) < [startmonth] and attr(month([Formatted Month]))!=month([startmonth]) then 0
elseif (attr(month([Formatted Month]))=month([startmonth]) OR (attr([Month]) >= [startmonth])) and attr([Month]) <= attr([EndMonth]) then (sum([NetValues]) - [margin])/(12-[startmonth])+1)
elseif ((attr([Month]) >= [startmonth]) and attr([Month]) > attr([EndMonth])) then (sum([NetValues])/12)
end

Let me know how to write this measure in Power BI

[v-diye-msft]

Hi @roma 

Hi @roma 

Here're some similar threads could be your reference, but if you provide the dummy pbix that would be much helpful for us to provide the valuable advice:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/IF-statement-with-multiple-columns-and-logica...

https://community.powerbi.com/t5/Desktop/IF-statement-as-measure/m-p/939608 

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example. Can you share sample data and sample output.

Appreciate your Kudos.

[parry2k]

@roma Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490