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  
