Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Show and Tell
  • jthomson's avatar
    jthomson
    7 years ago

    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

GetResponsive's avatar
GetResponsive
Regular Visitor
7 years ago

hi Anonymous 

 

did you make sure that Opportunity[Month] has a type of (whole) number and not text. You can recognize this if in the fieldlist no sigma icon is noted before the field name. In the (Power) Query Editor you can change the type to number. 

 

BR

 

Jeroen Heerschop

Get Responsive

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    for Month I have created Opprtunitymonth = month ( opportunity[Closedate])