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...
MattAllington
Community Champion
Community Championsorry, 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!