Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
maowi01
Frequent Visitor

Multiple Formulas in one Statement

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

🙂

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User
Super User

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur  THANK YOU

Lesson learnt- dont overthink the formula- Worked perfectly!

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.