cancel
Showing results for
Did you mean:
Frequent Visitor

## how to apply two condition simultaneously

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
Senior Member

Highlighted
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"))))))))

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")

Frequent Visitor

Not working

Senior Member

## Re: how to apply two condition simultaneously

what is the data type of KM/Day field?

Announcements

#### 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

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

#### Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)