Forum Discussion
DAX > M Query - LOOKUPVALUE
Any tips on how to convert this DAX over to M? The below displays as expected but I need the transformation to occur in Power Query to conduct subsequent steps on the existing [From Date] and gen...
Still getting an error. This time it's highlighted the end close bracket of the formula
v-juanli-msft
Community Support
Community SupportHi Anonymous
To help you slove it, please show the code below from your query.
******
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", (x)=>Table.SelectRows(Original,each [ID]=x[ID] and [Letter Date]=x[Original Date])),
*****Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.