Solved: Re: IF

Anonymous · ‎02-16-2021

Hi trying to create

=IF(table[ordertypeD] = "Normal Order"), table[feild],"")

Getting an error on "Normal Order"

Yet Normal Order exists in table[ordertypeD]

In fact I get an error as soon as i enter "

suggestions ?

pranit828 · ‎02-16-2021

Hi @Anonymous

Try

=IF(table[ordertypeD] = "Normal Order", table[feild],blank())

Hope it resolves your issue?
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

View solution in original post

Tahreem24 · ‎02-16-2021

@Anonymous ,

There is an Parenthesis error. It should be like:

=IF(table[ordertypeD] = "Normal Order", table[feild],"")

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

Anonymous · ‎02-16-2021

Anonymous · ‎02-16-2021

@Anonymous check the datatype once in the data tab....some times it could be datatype issue as well. or paste the sample data

Regards,

Husna

pranit828 · ‎02-16-2021

Hi @Anonymous

Try

=IF(table[ordertypeD] = "Normal Order", table[feild],blank())

Hope it resolves your issue?
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

Anonymous · ‎02-22-2021

Thanks mate....Syntax worked though was still getting the feilds appear red....Forgot to mention was DAX being used in Excel....The feilds stayed RED but the syntax worked and returned the desired result...thank you....!

Anonymous · ‎02-16-2021

Hi Pranit, no mate issue is not the blank "".....DAX is not recognising "Normal Order"

IF

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly