Transform a dax formula to custom column

[Anonymous]

Hello guys,

So i managed to write a DAX formula to do a Vlookup .

IF(MONTH(LOOKUPVALUE('Final PowerBI'[Close Date],'Final PowerBI'[ERP Project Number],'To_investigate'[ERP code],0))=5,"Late creation in SF","")

But i want to translate this in power querry editor when creating a new custom column. I tried to paste my formula but it does not work.

Best regards,

ScrappyS

[jthomson]

Well, no, it won't work in Power Query, as that uses M, not DAX - if you want to do it in Power Query, I'd do some sort of merge/join that replicates your lookup to get the value needed as a first step, then use the conditional logic you need in a second step