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"]
Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Can you share some sample data used in file 1a Recon Status Summary.xlsx? Please upload the file without confidential/sensitive data to a cloud storage service such as Onedrive/Google Drive/Dropbox/Box (Onedrive preferred) and share the link here.