Additional operations on a column before running total

twixy — Wed, 26 Feb 2025 06:27:30 GMT

Hi,

I have a column of revenue over a few different years. I currently have a running total measure for the revenue over time but would like to apply a multplication to the column (to reflect currency exchange rate) before computing the running total. Is it possible to do so with a measure? I tried ammending my current running total code but was unsuccessful.

Data

Year	Revenue	Country
2020	$100	A
2020	$120	B
2021	$130	B
2022	$100	B

Measure which is the Current Revenue ($) running total in Year returns a measure that when plotted gives 2020 - $220, 2021 - $350, 2022 - $450

I would l like it multiply the revenue by the correct exchange rate based on country and return the running total.

I.e. Exchange rate for country A = 0.5, Exchange rate for country B = 0.6.

Return 2020 = 0.6 x 100 + 0.8 x 120 = $156, 2021 = 156 +0.8 x 130 = $260, 2022 = 260 + 0.8 x 100 = $340

Thanks for any help you can provide!

Current running total code:

Current Revenue ($) running total in Year =

CALCULATE(

SUM('Tracker'[Current Revenue ($)]),

FILTER(

ALLSELECTED('Tracker'[Year]),

ISONORAFTER('Tracker'[Year], MAX('Tracker'[Year]), DESC)

Re: Additional operations on a column before running total

Sahir_Maharaj — Wed, 26 Feb 2025 09:04:57 GMT

Hello twixy,

Can you please try this approach:

Revenue_Running_Total_Converted = VAR ExchangeRate = SWITCH( SELECTEDVALUE('Tracker'[Country]), "A", 0.5, "B", 0.6, 1 ) RETURN CALCULATE( SUMX( 'Tracker', 'Tracker'[Revenue] * ExchangeRate ), FILTER( ALLSELECTED('Tracker'[Year]), ISONORAFTER('Tracker'[Year], MAX('Tracker'[Year]), DESC) ) )

Re: Additional operations on a column before running total

twixy — Wed, 26 Feb 2025 23:26:43 GMT

That worked, thanks Sahir_Maharaj !

topic Re: Additional operations on a column before running total in DAX Commands and Tips

Additional operations on a column before running total

Re: Additional operations on a column before running total

Re: Additional operations on a column before running total