Lookup value with condition if the existing column is blank

[Anonymous]

Hello Folks,

I need your help on creating a new column (Status) where if the Date Difference column has given below values then the new column (Status) should consist of these values:
If 8  then "1 Week"
If 175 then "6 months"
If 300 the "7 months"

If 120 then "4 months"
If 90 then "3 months"
However, if the Date Difference has blank value then lookup in the Result column where if its "Not Started" then new_status column should be "Not Started" otherwise "Date Not Found"

Have a look at the image below:

Thanks in Advance!

[Anonymous · Accepted solution]

Hi @Anonymous 

Create a calculated column like this :

New Status = SWITCH(TRUE(),'Table'[Date Difference]=8,"1 week",'Table'[Date Difference]=175,"6 months",'Table'[Date Difference]=300,"7 months",'Table'[Date Difference]=120,"4 months",'Table'[Date Difference]=90,"3 months",'Table'[Date Difference]=BLANK() && 'Table'[Result]="Not Started","Not Started","Date Not Found")

The result is as shown :

I have attached my pbix file ,you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , A new column like this

Switch( True(),
[result] = "Not Started" , "Not Started"

[result] <>  "Not Started", isblank([Date Difference]) , "Date not Found"
[Date Difference] < 8, "1 Week",
[Date Difference] < 175 , "6 months",
// Add others

, "Other"
)