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.
File is in the link above and I have highlighted the two columns Purple that I am trying to replciate in Power BI.
Would really appreciate any help you can provide.
Thanks,
6 Replies
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
Hi JP8991 ,
There is a LOOKUPVALUE function in Power BI. Refer following link:
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
Thanks,
Pragati
Hi , JP8991
I'm sorry that I'm not familiar with the formula in Excel, can you explain the logic briefly?
Best Regards,
Community Support Team _ Easonv-easonf-msft what I am trying to achieve is a running handicap based off each game played.
- Person registers to play and enters their base handicap in the Customers table.
- Then each round they play they enter their score, type of game played and length of course.
- If it is the players first game the handicap adjusts based off their base handicap in the Customers Table
- After that the handicap is based off the last game played.
