Multiple Formulas in one Statement

[maowi01]

Hi Team,

 I am trying to use multiple statements from Excel and convert to either a dax formula or a calculated column:

=IF(AB2="YES",SUM(X2/AC2),"0.00") 

the Columns are all within the same table.

I tried a calculate with and If and Sum.... Iferror with a Sumx ..... If , sum, filter..... No luck

Your advice and expertise, greatly appreciated

🙂

[Ashish_Mathur · Accepted solution]

Hi,

You have not specified whether you need a calculated column or a measure.  If you need a calculated column formula, then try this

=if(Data[Reply]="Yes",divide(Data[column1],Data[column2]),0)

Data[Reply] is column AB

Data[column1] is X2

Data[column2] is AC2

Hope this helps.

[maowi01]

@Ashish_Mathur  THANK YOU

Lesson learnt- dont overthink the formula- Worked perfectly!

[Ashish_Mathur]

You are welcome.