Formula DAX

[Jizquierdo]

Good morning everyone, starting with power bi and first time on the forum
I have a question and I hope you can help me.

I have the following formula

USDSalesLYTD =
SUMX(
'DWH Made_Sales',
YEAH(
'DWH Fact_Sales'[Country_ID] = 1,
[SalesLYTD] / 575, IF( 'DWH Fact_Sales'[Country_ID] = 2,
[SalesLYTD] / 7.68, [SalesLYTD] * 1
)
))

which gives me a result in the blank table

the SALESLYTD formula

SalesLYTD = CALCULATE([NetSales],SAMEPERIODLASTYEAR(Dim_Time[Date]))

What I am looking for is to calculate last year's sales in the same period and then apply a currency exchange according to the country code

[Anonymous]

Hi @Jizquierdo 

What are the fields in the DWH Made_Sales and DWH Fact_Sales? Are there any relationships between the two tables?

Please share some data(exclude sensitive data), or create some sample data, so that we can help you better.

You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.