Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
I found salutions from this form
My formula should be like this:
U.E Remaining collcection = if(ISFILTERED('Курса валюты Доллар США'[Дата]);sum(Contract_3[Остаток невыплаченных средств])/VALUES('Курса валюты Доллар США'[Курс]);SUM(Contract_3[Остаток невыплаченных средств]))
I found salutions from this form
My formula should be like this:
U.E Remaining collcection = if(ISFILTERED('Курса валюты Доллар США'[Дата]);sum(Contract_3[Остаток невыплаченных средств])/VALUES('Курса валюты Доллар США'[Курс]);SUM(Contract_3[Остаток невыплаченных средств]))
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |