Forum Discussion
Solved
Convert Months to weeks
Hello Guys., Hope you can suggest something I have a column with "X" numbers of rows with amounts and linked to another column with dates, but just by Month , (I can add year-Q-month and day )...
Hello everyone, I found a very simple solution ! I just split the total I had in colum (YTD) btw 52 weeks , and that result multiplied per the week we are currently ( week 25). Thank you all for your help ! :D
I'm not clear on your data format (original) but I am betting that WEEKNUM will play a role in this:
Thank you, ! That could be a solution if I use DAX , but in this case I am using power query ... :(