Forum Discussion

Anonymous

Not applicable

4 years ago

DAX

Hi All, I have attached 2 images below. They are both in the same table, just different regions. The problem is, for the region EMEA, I need to apply exchange rates. Hence I ha...

goncalogeraldes

Super User

4 years ago

Hello there Anonymous ! If I understood your problem correctly, I think solution may work:

R+ Order Value = 
IF(
'R+ Orders'[PartPlantbyYearWeekNum] in { "EMEA", "NA"},
DIVIDE( 'Part File'[PartPlantbyYearweekNum] , 'Part File'[Exchange Rates] ),
BLANK()
)

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes

Anonymous
Not applicable
4 years ago
Hi goncalogeraldes ,

Thank you!
I applied the formula. Now itseems to be blank for both NA and EMEA.
- goncalogeraldes
  Super User
  4 years ago
  I've had a look at your table and isnt it supposed to check the values in the "Region" column rather than the "PartPlantbyYearWeekNum"? Like this:
  
  R+ Order Value = IF( 'R+ Orders'[Region] in { "EMEA", "NA"}, DIVIDE( 'Part File'[PartPlantbyYearweekNum] , 'Part File'[Exchange Rates] ), BLANK() )
  
  Hope this answer solves your problem! If you need any additional help please tag me in your reply.
  If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
  Thanks!
  
  Best regards,
  Gonçalo Geraldes
  - Anonymous
    Not applicable
    4 years ago
    Thank you!
    I actually get the R+ order value from an other table. I have done a lookup in the above formula I have applied. And I need to apply the exchage rate, i.e., divide R+ order value(which i have got by applying lookup) by exchage rate. And I only need to apply that, i.e., divide by exchange rate for EMEA region and not NA.

Related content