Forum Discussion

Swa_rna's avatar
Swa_rna
New Member
6 months ago
Solved

undefined

Hi I need a help on matrix in Power bi. I have two dimensions revenue and expense from two different dimensions tables. Matrix should show: Revenue.           Year.   Amount Cost centre 1 Cost c...
Need Help
  • sanalytics's avatar
    sanalytics
    6 months ago

    Swa_rna 

    First of all, please provide more information about your data model. Based on the details you have shared, I assume you may need to create a bridge table by combining all the IDs from the revenue and expense dimensions.

    I have given it a try, and below are the file and screenshot for your reference.

    Hope it will work. If it is not, please provide more information about your data and data model.

     

    Regards,

    sanalytics

     

v-aatheeque's avatar
v-aatheeque
Icon for Community Support rankCommunity Support
6 months ago

Hi Swa_rna 


Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.

v-aatheeque's avatar
v-aatheeque
Icon for Community Support rankCommunity Support
6 months ago

Hi Swa_rna 

Have you had a chance to look through the responses shared earlier? If anything is still unclear, we'll be happy to provide additional support.