Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
lcanal
Frequent Visitor

Dynamic currency convertion with start and end date

‎07-26-2017 11:31 AM

Hi

We have 3 tables:

 

ER.PNG

 

 

CURRENCY

 

CURRENCY.PNG

 

RATES

 

RATES.PNG

 

SALES

 

SALES.PNG

 

 

Our goal is to show ConvertedAmount in SALES, based on wich CURRENCY user selected in a Slicer.

 

Thank's!!!

Labels:
Message 1 of 4
934 Views
0
1 ACCEPTED SOLUTION
v-yulgu-msft
Microsoft Employee
Microsoft Employee

‎07-27-2017 11:53 PM

Hi @lcanal,

 

Please refer to below measures:

Selected Rate =
CALCULATE (
    LASTNONBLANK ( RATES[RATE], 1 ),
    FILTER ( RATES, RATES[STARTDATE] >= MAX ( SALES[DATE] ) )
)

ConvertedAmount = MAX(SALES[AMOUNT])*[Selected Rate]

2.PNG

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Message 2 of 4
1,040 Views
0
3 REPLIES 3
v-yulgu-msft
Microsoft Employee
Microsoft Employee

‎07-27-2017 11:53 PM

Hi @lcanal,

 

Please refer to below measures:

Selected Rate =
CALCULATE (
    LASTNONBLANK ( RATES[RATE], 1 ),
    FILTER ( RATES, RATES[STARTDATE] >= MAX ( SALES[DATE] ) )
)

ConvertedAmount = MAX(SALES[AMOUNT])*[Selected Rate]

2.PNG

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 2 of 4
1,041 Views
0
lcanal
Frequent Visitor
In response to v-yulgu-msft

‎07-31-2017 05:17 AM

Thank's  a lot @v-yulgu-msft

Message 3 of 4
900 Views
0
v-yulgu-msft
Microsoft Employee
Microsoft Employee
In response to lcanal

‎08-01-2017 01:00 AM

Hi @lcanal,

 

Have you worked it out? If so, please kindly mark the helpful reply as an answer so that more users can benefit from it. If you still have any concern, please feel free to ask.

 

Thanks,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 4 of 4
895 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All