Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Completing a date table with currencies

We integrate a currency conversion in Power BI and have used Euro Stat for this. This works so far that we have all currency conversions for working days. Currently it looks like this:      ...
Need Help
Show and Tell
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi Anonymous 

     

    I have attached my sample file at bottom. Hope it helps. Prepare a full date table and attribute table in advance. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
3 years ago

If you want to Merge you could make 2 copies of the date table and in each of them add a column for currency. In one USD and in the other CNY.

Then Append those tables together.

Then do the Merge. Left-join from this large table to currency table, join on date and currency.

That should get you a large table with no values for exchange rates on some dates. Replace those empty values with null.

If you then sort that table by currency AND date, I think you might get away with a 'Fill Down'.  I'm just visualising in my head at this stage.  See how you get on.