Formula DAX

Jizquierdo — Wed, 17 Jul 2024 17:21:29 GMT

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

Re: Formula DAX

Anonymous — Thu, 18 Jul 2024 02:02:51 GMT

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.

topic Re: Formula DAX in DAX Commands and Tips

Formula DAX

Re: Formula DAX