Forum Discussion
eduardosilvin3
Helper II
Helper IITable from month to daily
Hello all, I need your help, I have a table with values per month and each month is in a different column, with the header as the first day of the month just as reference for that month. What I need ...
I attached a .pbix file showing the steps and solving the problem for you in Power Query.
1) unpivot columns to the right of Col3
2) Add Days in Month column
3) Divide value by Days in Month
4) Add "End of Month"
5) Add List of values between start of month and end of month.6) Expand the list
//// Mediocre Power BI Advice, but it's free ////
kpost
Solution Sage
Solution SageI edited my original response to include a new .pbix file with the solution I believe you are looking for.
It fills in each row with every date in the month as a new column, as well as the [value] / [Days in Month] column.
eduardosilvin3Helper II
Helper IITHAAANK YOU SO MUCH, worked perfectly.
Have a great day!