Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
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)  ...
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Use below formula in a custom column

    = if [#"Group - Account Description"]="" then Text.From([Account])&"."&Text.From([Profit Center]) else [#"Group - Account Description"]
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

101 would be Example

103 would be 100003.103 

If Group Account Description is blank then return Account.Profit Center else return the value in Group Account Description

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Use below formula in a custom column

= if [#"Group - Account Description"]="" then Text.From([Account])&"."&Text.From([Profit Center]) else [#"Group - Account Description"]