Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Convert data from monthly format into weekly



I have three different sheets. 1 Sheet has data in a weekly format. and other sheets having data in a monthly format.
I want to convert monthly data into weekly and append all three sheets. How to do this in power bi?

Expected Output : 

Sr.No.    Customer Code     Jan23(Week1)   Jan23(Week2)   Jan23(Week3)  Jan23(Week4)  Jan23(Week5) 

Every month should divide into weeks.
I don't have a date column.


Please help.

No Replies