How to calculate YTD with different previous exchange rate?

[Anonymous]

Hi,

How can I get YTD with specific exchange rate in related month?

For example, I want to have sum of Apr and May 2021 in C2, it should be 7,171,715, but I only get 6,703,246 (C3), the reason is

in C3 it comes (3406432+3296812)*0.94 however I want to have 3406432*0.93+3296812*0.94 (first two month YTD).

How can I get that YTD function ?  Thank you so much guys.!

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please follow the steps:

1.Create a measure to calculate the true_sales and add to the table visual object

true_sales =
SUMX ( Sheet1, Sheet1[Sales] * Sheet1[Exchange rate] )

2.Create a measure to calculate the YTD sales and add to the table visual object

YTD_Sales =
TOTALYTD ( [true_sales], Sheet1[MonthInCalendar] )

3.You will get below table visual object

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , if you use the time intelligence function with the date table you can change FY for YTD. Apr-Mar FY YTD

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"3/31"))