Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
7 | |
6 |