parent child hierarchy in direct lake model - adding Levels to Table

[abhiram342]

Hi all - I have a table with ParentId and ChildId columns, and I want to create a hierarchy for DisplayName using the Path function. However, I don’t see an option to add a new column in a Direct Lake model. Could you suggest any workarounds? One possible approach I found is to add the hierarchy in the lakehouse and then include it in the model.

Thanks,

Abhiram

[MFelix]

Hi @abhiram342 ,

You cannot create new columns using DAX on the direct lake mode, for this you need to create your Parent / Child on the Lakehouse/Warehouse using SQL or Python.