Forum Discussion
How to structure lookup table hierarchy
Hi I am trying to create a lookup table within Power BI. The idea is that I should be able to retrieve my data at any of the four column levels below: Financial Statement Category FS Acc...
You will need to create the top table. I’m sure it can be done in Power Query. Can you post some sample data?
Could you clarify what you mean by "top table?" And by sample data, are you referring to hierarchy data or fact data?
sorry, I was referring to the 3 images in your OP. I was referring to the top one.
Ok that makes sense. So I would need to delete out unnecessary sub-hierarchies? Is there a way to do that other than by manually deleting out in excel? Thanks!