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
v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
4 years ago

Hi diegoadum ,

 

Do you mean you want to implement the requirements in power query? Can you end the meaning of the specific fields and the expected result you expect, I will answer you as soon as possible.


Best Regards,
Henry

 

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

Hi Henry, the values will be part of the formula within the Power Query. The whole exercise in focusing on inventory revaluation which is a common problem in countries with high inflation scenarios. So far, I solved the problem by adding as many records as months exist in the year due to my union needs Year as well as Month between the two tables. The main goal is to create a calculated column with the revaluation amount. Thanks!