Forum Discussion

Shackwell's avatar
Shackwell
Icon for Helper III rankHelper III
2 years ago

division in a matrix

Hello there.   I am trying to divide the results on 2 matrices within my power bi report.   First Matrix is like this                 TOTAL SALES 2018,    TOTAL SALES 2019 , TOTAL SALES 2020 ZO...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
2 years ago

Raw data that you are brining into Power BI without any transformation.

  • Shackwell's avatar
    Shackwell
    Icon for Helper III rankHelper III
    2 years ago

     here is a small sample. I am using "bridge" connections to link the databases. In this case I inserted ZONE on the PBI catalog manually. And I have also a list of all the ITEMS to be sold. So I created a matrix between these 2 "bridges" and then im filling such matrices with the information I imported from excel. I am not sure if Im being clear with this or do I need a further clarification. Thank you for your time.