Dynamic measure - filtered month
Hi all, Master Table: main tablewhere I have the values "Balance" per each Month/Currency. Fx Historical Rate: table that report all the exchange rates. I need to calculate the "Monthly Sales €", for example of March, as the difference betwwen YTD 03 @ 03 Act Rate - YTD 02 @ 02 Act Rate. This measure have to be dynamic, so if I filter "03" in the "Month Filter" I want to see 372 in the table. 4.660 If I filter "02" and so on. Each balance amount have to be converted using the correct exchange rate. Can you help me? Thanks in advancesummation of currency not working
Hi! I have a table with AgreementLines all in local currency. Example: I have currencyRate table to be able to make a measure to calculate the currency of each row to NOK. I made a measure on my AgreementLine Table called "Total NOK": Total NOK = VAR _currency = MAX(AgreementLine[Cur] ) VAR _conversionRate = CALCULATE( MAX( CurrencyRate[Rate] ) ,CurrencyRate[TransactionCurrency] = _currency ) VAR _TotalInNok = SUM(AgreementLine[Total]) * _conversionRate RETURN _TotalInNok This works very well and the numbers are correct per row in my AgreementLine table. The problem is if I want to sum the field "Total NOK" in a table view or Card. TableView will end up like this: The correct sum for "Total NOK" would be: 39 432,53. I understand the logic, but what I want to achieve is to SUM each row of "Total NOK" which is already calculated. What is the best approach to deal with local currency and get this setup for my reports?
