Forum Discussion

Kjellke's avatar
Kjellke
Helper I
4 years ago

Table not showing summarized values

Hi, i am quite new to Power BI, but i am trying to make some with data ive successfully exported from our ERP system. I am now trying to have two collumns that one that summarize the positive numb...
Need Help
Kjellke's avatar
Kjellke
Helper I
4 years ago

Dear Edhans,

Thank you very much for your feedback. The collumn 1 and collumn 2 is just names for the collumns in the visual table.

All calculations from the table is done in calculation INN, UT and UTTAK.

="2901" and <>122 is filtered values from different collumns from my data table, as i am exporting accounting data from our ERP system, numbers are from different accounts and categories.

 

PROJTRANSPOSTING[AMOUNTMST] can be costs, revenue or profits - it just depends on these filters/categories.

Unfortunately i dont think i will be able to share any data - I will check tomorrow if we have some "dummy" data in our ERP system to avoid sharing any confidential information.

I will take note of your comment regarding "" as else, and use BLANK() instead.

 

Since my visual table collums show data calculated from several database tables that are connected, i dont know how to compute this inside a new database table collumn.

  • edhans's avatar
    edhans
    Community Champion
    4 years ago

    You can use RELATED or RELATEDTABLE to get data from one table into another in a calculated column.

    That said, I, like you, much prefer a measure, but I'd need some fake data to assist with here.


    • Kjellke's avatar
      Kjellke
      Helper I
      4 years ago

      Dear Edhans,

      Thanks again for your involvement. I am trying to sort out how to export raw data from my power bi data tables.

      All my data is exported/connected to the SQL server of our ERP system - And i cannot seem to find an easy way to export this.