Replicate Excel Lookup Function

[JP8991]

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.

Excel File

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,

[v-easonf-msft]

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 _ Eason

[JP8991]

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

[Pragati11]

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

[amitchandak]

@JP8991 , refer if this can help

https://eriksvensen.wordpress.com/2019/02/28/powerquery-replicate-doing-an-excel-vlookup-in-m/

[JP8991]

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

[amitchandak]

@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/1...

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