Forum Discussion

Jizquierdo's avatar
Jizquierdo
New Member
2 years ago

Formula DAX

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.