Forum Discussion
Generate Lookup tables from Main Table in PowerBi based on Column Value
Hi,
I want to create (generate/automate) lookup tables from a large excel file containing keys (integers) and descriptions for each key, it looks something like this:
I can manually do this by filtering each "list_name" and create a lookup table, however, is there a way I can automate this process perhaps using DAX?
Regards,
Ayub
2 Replies
- Idrissshatila
Super User
Hello AyubZafar ,
unfortunately, you should do the work either here, or if you having the in a database, then yoou can do it there.
Idrissshatila any possibility DAX or other scripting within PowerBi could help with this?
