Forum Discussion

eduardosilvin3's avatar
eduardosilvin3
Icon for Helper II rankHelper II
2 years ago

Add new calculated rows in matrix

Hello all, I have this calc table, comes from a table where I have in the same rows "sales" and "costs".... so this was to get all the rows and add it in the same column, now I have all as I need in ...
Need Help
eduardosilvin3's avatar
eduardosilvin3
Icon for Helper II rankHelper II
2 years ago

thanks for the answer, but I did not get how to replicate your file into my file

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    2 years ago

    Can you please share your demo input and expected output!

    • eduardosilvin3's avatar
      eduardosilvin3
      Icon for Helper II rankHelper II
      2 years ago

      Thanks, here are the files. I created a non sensitive data file, it really comes from SQL Server, but I replace everything from the excel. So I have 4 tables, 2 from the DB (the DB and some Power Query codes to get the structure I need to show in the matrix). The 3rd table is to separate in one whole table by costs and revenues, because they are in the same rows. And the 4th is for dates.

      So now I must add contribution, contribution %, EBITDA, etc (the rows I added in power query to get the structur). All those calculations comes from the DB table, but now I am lost how add those calculations in the matrix as extra rows, following the 'DB Structure' table, not only as a measure appart and have the possibility to filter by all the other columns in the original DB. I have all the calculations but I dont know how to add it to the matrix.

       

      Hope you can have any idea that can help.

      Regards!

       

      PBI Help