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
Mark_Timson's avatar
Mark_Timson
Helper I
7 years ago

Hi, 

 

Im not trying to sum both together Im trying to return one or the other based on the data in the table. 

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Mark_Timson ,

If it is convenient, could you share your data sample and your desired output so that we could help further on it?

Best  Regards,

Cherry