Forum Discussion

Topgunz786123's avatar
Topgunz786123
Regular Visitor
8 years ago
Solved

Is Not Blank and Is Blank

Hi All,   I have a data set which has Account Names, Parent of Account Names, Grandparent of Account Names, and Great Grandparent of Account Names.   What I'm trying to do is create a Custom Colu...
Need Help
  • askelton's avatar
    askelton
    8 years ago
    Column = 
if('Account Hierarchy'[Great Grandparent Name]<> BLANK(),
    'Account Hierarchy'[Great Grandparent Name], 
    if('Account Hierarchy'[Grandparent Name]<> BLANK(),
        'Account Hierarchy'[Grandparent Name],
        if('Account Hierarchy'[Parent Name]<> BLANK(),
            'Account Hierarchy'[Parent Name],'Account Hierarchy'[Account Name])))
askelton's avatar
askelton
Icon for Resolver I rankResolver I
8 years ago
Column = 
if('Account Hierarchy'[Great Grandparent Name]<> BLANK(),
    'Account Hierarchy'[Great Grandparent Name], 
    if('Account Hierarchy'[Grandparent Name]<> BLANK(),
        'Account Hierarchy'[Grandparent Name],
        if('Account Hierarchy'[Parent Name]<> BLANK(),
            'Account Hierarchy'[Parent Name],'Account Hierarchy'[Account Name])))