Forum Discussion
Replicate Excel Lookup Function
Hi all, I am trying to replicate two columns I have created in Excel in Power BI. I don't mind if it is done in DAX or M however I would probably prefer M as I can use it in Dataflows or Excel...
JP8991 , refer if this can help
https://eriksvensen.wordpress.com/2019/02/28/powerquery-replicate-doing-an-excel-vlookup-in-m/
amitchandak Pragati11 thanks for the guides however I am stuck and could really do with some help on this one.
I don't think either guide can help me in the example I provided.
JP8991 , sometime back Greg_Deckler has strated a series Excel to DAX.
I have one link handy from that -https://community.powerbi.com/t5/Community-Blog/Part1-Reflections-on-Excel-to-DAX-Translation/ba-p/1088231
But do not see that function.
Greg_Deckler is there something on the user wanted. or Lookupvalue should suffice the need
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax