Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Price Volume Mix analysis in Power BI

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. 

 

Data Modeling

3 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Anonymous ,

     

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

     

    Regards,

    Jimmy Tao

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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)DateMonthEntity NameDocCurCodeDocCurValueHQCurCodeHQCurValueQuantityProduct CodeCountry Name
      PY3/7/2018MarchXYZ CompanyUSD                 1,000USD1000100G06ZB1LMS0NUnited Arab Emirates
      PY4/13/2018AprilXYZ CompanyEUR                 1,649USD1820200G06ZB1LMS0NGermany
      PY5/26/2018MayXYZ CompanyEUR                 2,473USD2730300G06ZB1LMS0NGermany
      CY3/7/2019MarchXYZ CompanyUSD                 4,100USD4100400G06ZB1LMS0NUnited Arab Emirates
      CY4/13/2019AprilXYZ CompanyEUR                 2,332USD2563250G06ZB1LMS0NGermany
      CY5/26/2019MayXYZ CompanyEUR                 1,399USD1538150G06ZB1LMS0NGermany

       

      Thanks,