Currency conversion Issue

Hello v-juanli-msft ,

Thanks for your response, you find bellow the link to the PBix file and also the twos sources files( i put all files to let you even prupose a new modeling if i didn't correctly).

Link: https://1drv.ms/u/s!Ajh-Pr8pM0w_bG6WApK-LFWvwTU?e=F0I0Py

after lot and lot of try and Just to remind the problem: the problem is that we can't work with totalYTD and TotalYTD(previousmonth()) inside a Sumx(table, expression)

using the files in the drive(Sales file, Currency rates exhange file) my manager need the Sales reports in euro currency and using this formula of exchanging ( Sales Euro Month=  divide(total sales YTD Month; Currency Exchange Rate Month) - divide(total sales YTD Month-1; Currency Exchange Rate Month-1)

Example: Sales Euro February =  divide(total sales YTD February; Currency Exchange Rate February) - divide(total sales YTD January; Currency Exchange Rate January).

let me know if you need any more information

Thanks in advance

Link: https://1drv.ms/u/s!Ajh-Pr8pM0w_bG6WApK-LFWvwTU?e=F0I0Py