cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
singhpratiksha8 Frequent Visitor
Frequent Visitor

how to apply two condition simultaneously

Capture.JPG

 

As mentioned in picture please cheeck the formula where i have created Km bucket through km/day column ,  but i need to run two conditon where if km/day =0 then it should come "NO kMS RUN  and  if  KM/day= Blank then it should come blank or null ... in upper mention formula if km/day is blank then also its coming under "No KM RUN"... please help 

5 REPLIES 5
SivaMani Senior Member
Senior Member

Re: how to apply two condition simultaneously

@singhpratiksha8,

 

Could please share your sample data?

singhpratiksha8 Frequent Visitor
Frequent Visitor

Re: how to apply two condition simultaneously

reg no        KM Bucket      KM/Day

 

A                NO KM RUN   

B                1-20 km             10km

C                no Km run          0 km

D                20-40                 25 km

 

 

in sample u can see if km/day is blank then also its coming NO RUN KMS and IF ITS 0 then also its coming NO RUN KM , i m using below mention formula, i need null or blank in km bucket if km/day is blank .  and if its 0 then it should come NO KM RUN

 

KM/Day Bucket = IF('Table'[KMS/day]>=100,"A. >100 kms", if('Table'[KMS/day]>=80,"B. 80-100 kms",if('Table'[KMS/day]>=60,"C. 60-80 kms", if('Table'[KMS/day]=40,"D. 40-60 kms", if('Table'[KMS/day]>=20, "E. 20-40 kms",IF('Table'[KMS/day]>0,"F. 1-20 kms",IF('Table'[KMS/day]=0 , "NO KMS RUN",IF('Table'[KMS/day]=BLANK(),"Null"))))))))

 

SivaMani Senior Member
Senior Member

Re: how to apply two condition simultaneously

Try this,

 

KM/Day Bucket = IF('Table'[KMS/day]>=100,"A. >100 kms", if('Table'[KMS/day]>=80,"B. 80-100 kms",if('Table'[KMS/day]>=60,"C. 60-80 kms", if('Table'[KMS/day]=40,"D. 40-60 kms", if('Table'[KMS/day]>=20, "E. 20-40 kms",IF('Table'[KMS/day]>0,"F. 1-20 kms",IF('Table'[KMS/day]=0 , "NO KMS RUN"))))))), "Null")

Highlighted
singhpratiksha8 Frequent Visitor
Frequent Visitor

Re: how to apply two condition simultaneously

Not working

SivaMani Senior Member
Senior Member

Re: how to apply two condition simultaneously

what is the data type of KM/Day field?

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)