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 

 

The SUM should not be before Opportunity[Month] indeed.

 

In addition: I see you using 3 different tables. Best is to have 1 table with the dates. And to have your various tables linked into this date table. Then you can use the month from the date table for your IF statement

 

Hope this helps

 

BR

 

Jeroen Heerschop

Get Responsive

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    If I remove Sum then I am not able to locate this column. Moreover all 3 tables are connected using month column and I need to calculate from different table values. is there any other way ? 

    • GetResponsive's avatar
      GetResponsive
      Regular Visitor
      7 years ago

      Hi Anonymous 

       

      Try to use MIN instead of SUM. It depends on context that you are using this formula in. Furthermore if you connected on month, is there a table with months/dates that linked the 3 tables into? You should use that month table as input for your calculation.

       

      Can you maybe share a part of your pbix? That makes it easier to answer.

       

      BR

       

      Jeroen Heerschop

      Get Responsive