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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
NEMAT2313
Regular Visitor

Help with DAX formula with filtered Exchange rate

Hi,

I want to add new column that converting USD currency to the below table. USD currency table comes from Central bank Web sites and I put there filter by date. Please help me to write DAX formula that converts to USD in the new added column.

 

Power BI exchange rate.png

1 ACCEPTED SOLUTION
NEMAT2313
Regular Visitor

I found salutions from this form Smiley Happy

 

https://community.powerbi.com/t5/Desktop/Control-which-currency-is-displayed-with-slicer/m-p/61259?l...

 

My formula should be like this: 

U.E Remaining collcection = if(ISFILTERED('Курса валюты Доллар США'[Дата]);sum(Contract_3[Остаток невыплаченных средств])/VALUES('Курса валюты Доллар США'[Курс]);SUM(Contract_3[Остаток невыплаченных средств])) 

View solution in original post

1 REPLY 1
NEMAT2313
Regular Visitor

I found salutions from this form Smiley Happy

 

https://community.powerbi.com/t5/Desktop/Control-which-currency-is-displayed-with-slicer/m-p/61259?l...

 

My formula should be like this: 

U.E Remaining collcection = if(ISFILTERED('Курса валюты Доллар США'[Дата]);sum(Contract_3[Остаток невыплаченных средств])/VALUES('Курса валюты Доллар США'[Курс]);SUM(Contract_3[Остаток невыплаченных средств])) 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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