Forum Discussion

diegoadum's avatar
diegoadum
Icon for Helper I rankHelper I
4 years ago

Join tables with missing values? or fill the gaps?

Hi folks, I think I'm overcomplicating here so I need your wise support!!    I have 2 tables, one is transactions and the other is currency rates. On the currency rates, I have the rates for a part...
Need Help
Tips and Tricks
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

Currency conversion can be a big headache. I recommend checking out this article for some best-practice patterns for it: https://www.daxpatterns.com/currency-conversion/

 

In any case, you'll almost certainly want a Date table to work with in your report.

diegoadum's avatar
diegoadum
Icon for Helper I rankHelper I
4 years ago

Thank Alexis for your help, but in this case, I'm forced to apply the solution as M language inside Power Query, (I should say that before!! 😉 due to base on this info I need to still work with some other fields.