Price Volume Mix analysis in Power BI

[Anonymous]

In Power BI I am working on Price volume mix analysis for a manufacturing company in which I am facing issues for forex calculations at product level. I want to analyze product sold in current year vs previous year as per billing date, if a product is newly introduced in current year how to compare it with previous year with same date and month but different year. 

For example: 'xyz' product is sold on 2/8/2019 but was not introduced in previous year 2/8/2018 how to calculate the forex impact. 

[v-yuta-msft]

@Anonymous ,

Please share some sample data and clarify more details about your requirement.

Regards,

Jimmy Tao

[Anonymous]

Please have a look at the sample data in below table, we have CY vs PY and want to use Sumifs formula for our different criteria’s such as month, product code, country name, DocCurCode in Power BI in order to get results. Can you please suggest a solution to this in Power BI?  

Period (Prior Year/ Current Year)	Date	Month	Entity Name	DocCurCode	DocCurValue	HQCurCode	HQCurValue	Quantity	Product Code	Country Name
PY	3/7/2018	March	XYZ Company	USD	1,000	USD	1000	100	G06ZB1LMS0N	United Arab Emirates
PY	4/13/2018	April	XYZ Company	EUR	1,649	USD	1820	200	G06ZB1LMS0N	Germany
PY	5/26/2018	May	XYZ Company	EUR	2,473	USD	2730	300	G06ZB1LMS0N	Germany
CY	3/7/2019	March	XYZ Company	USD	4,100	USD	4100	400	G06ZB1LMS0N	United Arab Emirates
CY	4/13/2019	April	XYZ Company	EUR	2,332	USD	2563	250	G06ZB1LMS0N	Germany
CY	5/26/2019	May	XYZ Company	EUR	1,399	USD	1538	150	G06ZB1LMS0N	Germany

Thanks,

[v-yuta-msft · Accepted solution]

@Anonymous ,

Generally, to create a sumif function in dax, I would suggest you refer to tutorial and similar cases below:

https://www.youtube.com/watch?v=iK__orX9XZo&vl=en

https://community.powerbi.com/t5/Desktop/SUMIF-Equivalent-in-DAX/td-p/230727

https://community.powerbi.com/t5/Desktop/SUMIFS-in-BI/td-p/180609

Community Support Team _ Jimmy Tao

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