Forum Discussion

Mark_Timson's avatar
Mark_Timson
Helper I
7 years ago

How to Sum based on an if statement

Hi all,   I was wondering if it was possible to do something similar to the below in power bi   IF Table.Col = "Y" THEN SUM(Table1.Col) ELSE IF Table.Col = "N" THEN SUM(Table2.Col) ELSE 0.   I ...
Need Help
Gordonlilj's avatar
Gordonlilj
Solution Sage
7 years ago
Hi,
You could try:
 
SWITCH(TRUE(),Table.Col="Y",SUM(Table1.Col),Table.Col ="N",SUM(Table2.Col),0)
  • Mark_Timson's avatar
    Mark_Timson
    Helper I
    7 years ago

    This didnt work as the column that is being filtered is not related I think.