Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Juleeees
Frequent Visitor

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: 

 

Juleeees_0-1669890060489.png

 

We would like to have a table where weekends and Public Holidays are included.

 

The idea was to take previous values. Whenever a value is missing, a previous value would have to be taken (idea was a loop, go back until value is filled in and then take this value).

 

For this, we need to add a complete date list + attribute (currency indicator). For example we need two rows for saturday(one for USD and one for CNY).

 

We have a full calendar in our PBI file that could be used for joints or whatever the idea is.

 

Thanks in advantage

 

1 ACCEPTED SOLUTION

Hi @Juleeees 

 

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

vjingzhang_0-1670320784058.png

 

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

View solution in original post

3 REPLIES 3
Juleeees
Frequent Visitor

Thanks for your help. 

 

This was an Example: We have 20+ Currencies, so this way would be too large for power bi. We need an directer solution

Hi @Juleeees 

 

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

vjingzhang_0-1670320784058.png

 

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

HotChilli
Super User
Super User

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.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors