Forum Discussion

PowerBIUser1990's avatar
PowerBIUser1990
New Member
4 months ago
Solved

Combining Column Data

Hi, I am new to Power BI and have been given the task of creating dashboards for property types in my local area. The database being used has 4 levels for each property type but only some are requir...
Need Help
  • rohit1991's avatar
    rohit1991
    4 months ago

    Hii PowerBIUser1990 

     

    You can create a calculated column to always return the deepest non-blank level using DAX:

    Property Type =
COALESCE(
    'Table'[Level 4],
    'Table'[Level 3],
    'Table'[Level 2],
    'Table'[Level 1]
)

    For Property Category, if it is driven by Level 2:

     

    Property Category =
COALESCE('Table'[Level 2], 'Table'[Level 1])

    This ensures consistent classification and works correctly across all visuals and slicers.

     

     

     

PowerBIUser1990's avatar
PowerBIUser1990
New Member
4 months ago

Not sure I can explain it in another way. Thanks for your help anyway I will just advise my Manager I cannot provide what he wants.

v-tejrama's avatar
v-tejrama
Community Support
4 months ago

Hi PowerBIUser1990 ,

 

Thank you Natarajan_M  for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you.