Forum Discussion
Currency Conversion rate + Sum
Hi, I'm sure this may be confusing so i've shared a bit of an overview in excel. The field i'm trying to replicate in DAX is [Generated Fees] in Table 1. I need to match both [Location - Country]...
- Without reading your post too carefully, I think you're looking for an approximate lookup in DAX. See if this post helps get you in the right direction and then come back with your further questions:
https://excelwithallison.blogspot.com/2020/06/dax-approximate-lookup.html
AllisonKennedy
Community Champion
Community ChampionWithout reading your post too carefully, I think you're looking for an approximate lookup in DAX. See if this post helps get you in the right direction and then come back with your further questions:
https://excelwithallison.blogspot.com/2020/06/dax-approximate-lookup.html
https://excelwithallison.blogspot.com/2020/06/dax-approximate-lookup.html