Forum Discussion

Anonymous

Not applicable

6 years ago

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...

Need Help

Anonymous

Not applicable

6 years ago

I've tried to apply the logic via a Custom Column but am getting a "Token Comma expected" error.

(x) => Table.SelectRows(#"FV-ToDt",
each [Employee ID] = x[[Employee ID]
and [To Date]=x[From Date]
)

v-juanli-msft

Community Support

6 years ago

Hi Anonymous

(x) => Table.SelectRows(#"FV-ToDt",
each [Employee ID] = x[[Employee ID]
and [To Date]=x[From Date]
)

[[ should be [.

Best Regards

Maggie

Anonymous
Not applicable
6 years ago
Still getting an error. This time it's highlighted the end close bracket of the formula
- lbendlin
  Super User
  6 years ago
  show the entire line of code
- v-juanli-msft
  Community Support
  6 years ago
  Hi 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.
- v-juanli-msft
  Community Support
  6 years ago
  Hi Anonymous
  
  Is this problem sloved?
  
  If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?
  
  If not, please feel free to let me know.
  
  Best Regards
  
  Maggie

Forum Discussion

DAX > M Query - LOOKUPVALUE

Related content

M Query lookupvalue

Query Form? LOOKUPVALUE?

Lookupvalue in Power Query

lookupvalue

lookupvalue PBI