Forum Discussion
PowerBI if condition not working
It return all record with 0 IF(SUM(Opportunity[Month]) in {1,2,3,4,5,6, 7} , ( SUM('August 2019'[Revenue]) - SUM('2018 Invoice'[Revenue])) , 0) if month is select 1 to 7 it should show this...
Don't know why you don't reword it as if (Opportunity[Month]<8), not sure why there's a sum there at all and it looks much cleaner
jthomson
Solution Sage
Solution SageDon't know why you don't reword it as if (Opportunity[Month]<8), not sure why there's a sum there at all and it looks much cleaner