Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
@Anonymous ,
Please share some sample data and clarify more details about your requirement.
Regards,
Jimmy Tao
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,
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
107 | |
69 | |
68 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |