cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Column - If Value is Blank then One Value, All the Rest Another Value

I need help...

 

I need a formula where if the value in a field is Blank, the return should be "Street Account", all the rest of the value should be "Corporate Account".

I am not sure how do this. I have included a screenshot.

 

IsBlank.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Column - If Value is Blank then One Value, All the Rest Another Value

Hi there

If you are trying to do this I would do it in Power Query.

I would create a new conditional column called All Accounts.
And where Corporate Account is BLANK or NULL then [Street Account] else [Corporate Account]




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
Highlighted
Super User IV
Super User IV

Re: Column - If Value is Blank then One Value, All the Rest Another Value

Hi there

If you are trying to do this I would do it in Power Query.

I would create a new conditional column called All Accounts.
And where Corporate Account is BLANK or NULL then [Street Account] else [Corporate Account]




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Highlighted
Helper I
Helper I

Re: Column - If Value is Blank then One Value, All the Rest Another Value

Perfect!

Thank you! My problem was I didn't put equal blank or null.

Highlighted
Super User IV
Super User IV

Re: Column - If Value is Blank then One Value, All the Rest Another Value

Awesome, glad that you got a solution!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors