Forum Discussion
Solved
Lookup Value and Transform
I have a two tables coming from a SQL database (a List of Asset Transactions table and a Security Class Key table). I have succesfully used LOOKUPVALUE to add a new column to the transaction list ta...
You can create table to PowerBI and add the columns you needed and then export it.
if you create new column using DAX function, you will not see those field in Power BI Data Model, to see these in Data model, you have to create those fields in model, in this case you can use merge queries in data model (as far as I understood from you post).If need further help, let me know and I can provide some samples.
Thanks,
P
