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

[Mangnuel]

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

 

[Mangnuel]

ok,
attached a link to google drive with two files. An excel sheet shwowing the desired result and a powerbi file with the current status.
Thanks a lot

https://drive.google.com/drive/folders/1iHigYJkfmIrp-XjgepSir1274pPFOpB9?usp=sharing 

[v-dineshya · Accepted solution]

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]

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

[v-dineshya]

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

[v-dineshya]

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

[v-dineshya]

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

[FBergamaschi]

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