Forum Discussion
Mark_Timson
Helper I
Helper IHow 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 ...
Gordonlilj
Solution Sage
Solution SageHi,
You could try:
SWITCH(TRUE(),Table.Col="Y",SUM(Table1.Col),Table.Col ="N",SUM(Table2.Col),0)
Mark_TimsonThis didnt work as the column that is being filtered is not related I think.