Forum Discussion
DAX in Direct Query
Hi tsarun1992 ,
In direct query connection mode many dax functions will be limited. So you can clean the data in power query.
Please check out the demo in the attachment. It's a solution in Power Query (the Custom column).
(let currentCustomer = [CustomerName] in Table.SelectRows(Table1, each [CustomerName] = currentCustomer)){0}[CustomerID]You can refer to the following documents that may be helpful to you:
How to CONCATENATE in Power Query ?- with Examples (gyankosh.net)
Power BI Concatenate Stings with Power Query M Language (mssqltips.com)
LOOKUPVALUE in PowerQuery - Power BI Ninjas
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi tsarun1992 ,
In direct query connection mode many dax functions will be limited. So you can clean the data in power query.
Please check out the demo in the attachment. It's a solution in Power Query (the Custom column).
(let currentCustomer = [CustomerName] in Table.SelectRows(Table1, each [CustomerName] = currentCustomer)){0}[CustomerID]
You can refer to the following documents that may be helpful to you:
How to CONCATENATE in Power Query ?- with Examples (gyankosh.net)
Power BI Concatenate Stings with Power Query M Language (mssqltips.com)
LOOKUPVALUE in PowerQuery - Power BI Ninjas
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.