Forum Discussion
Solved
Consolidating Helper Column into Single Column with Nested Functions
I have one column that lists the Group Name Description if the Account is grouped, if the account is not grouped it returns a blank text value (not best practices but can't change the data source) ...
Use below formula in a custom column
= if [#"Group - Account Description"]="" then Text.From([Account])&"."&Text.From([Profit Center]) else [#"Group - Account Description"]
Nope wont be able to share that but here is a sample data set just using 15 lines
| Account | Profit Center | Group - Account Description |
| 100001 | 101 | Example |
| 100002 | 102 | Example |
| 100003 | 103 | |
| 100004 | 104 | Example |
| 100005 | 105 | Example |
| 100006 | 106 | Example |
| 100007 | 107 | |
| 100008 | 108 | |
| 100009 | 109 | |
| 100010 | 110 | |
| 100011 | 111 | Example |
| 100012 | 112 | Example |
| 100013 | 113 | Example |
| 100014 | 114 |
I went through your data and code. What is the result expected say for Profit center 101 and 103?