Forum Discussion

Mangnuel's avatar
Mangnuel
Icon for Helper I rankHelper I
1 year ago
Solved

Table-View <> how to add new columns with functions

Good morning Forum,

 

I need your help, please 🙂

Want to add a few columns to an existing table
(Can't do it with measures within the report, the filtering is messing up the results if one switches between Daily/Monthly or Yearly resolution)

Table is simple, we have the values A, B, C and the date on daily resolution.
Goal is, to get the monthly sums for the Values A, B and C and put them into the daily resolution.
So e.g. January at the end gets 31 times the same monthly sum.

Can somebody help?
Attached is a picture from PowerBi and an Excel-File.
The file shows the wanted resolut and how the sums and formulars work.
Hope it's clear, don't mind asking.


Thanks a lot

 

 

 


 

Add Columns
Table-View
  • v-dineshya's avatar
    v-dineshya
    1 year ago

    Hi Mangnuel ,

    Thank you for sharing the files.  you are expecting the below result right?

     

    monthly Sum
    Month Value B Value C Division B/C
    1 7.3 10.41 70.1%
    2 8.13 13.61 59.7%
    3 42.2 50.36 83.8%
    4 61.3 73.29 83.6%
    5 22.32 26.95 82.8%
    6 79.8 95.77 83.3%

     

    The excel file that you have shared , it contains the source data right? 

     

     

    Regards,

    Dinesh

     

7 Replies

  • FBergamaschi's avatar
    FBergamaschi
    Icon for Super User rankSuper User
    1 year ago

    Please include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. 

     

    Need help uploading data? click here

     

    Want faster answers? click here

  • v-dineshya's avatar
    v-dineshya
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi Mangnuel ,

    Thank you for reaching out to the Microsoft Community Forum.

    Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
    Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
    Please show the expected outcome based on the sample data you provided.


    Regards,
    Dinesh

    • v-dineshya's avatar
      v-dineshya
      Icon for Community Support rankCommunity Support
      1 year ago

      Hi Mangnuel ,

      Thank you for sharing the files.  you are expecting the below result right?

       

      monthly Sum
      Month Value B Value C Division B/C
      1 7.3 10.41 70.1%
      2 8.13 13.61 59.7%
      3 42.2 50.36 83.8%
      4 61.3 73.29 83.6%
      5 22.32 26.95 82.8%
      6 79.8 95.77 83.3%

       

      The excel file that you have shared , it contains the source data right? 

       

       

      Regards,

      Dinesh

       

      • v-dineshya's avatar
        v-dineshya
        Icon for Community Support rankCommunity Support
        1 year ago

        HI Mangnuel ,

        We haven’t heard from you on the last response and was just checking back to see. And, if you have any further query do let us know.

         

        Regards,

        Dinesh