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
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 ?
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