Forum Discussion

Geraldine's avatar
Geraldine
Frequent Visitor
10 years ago
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 )...
Need Help
  • Geraldine's avatar
    Geraldine
    10 years ago

    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

kcantor's avatar
kcantor
Community Champion
10 years ago

Geraldine

 Re-do

I have actually dealt with this before. I simply split the column in PowerQuery to only show the end date (last part of the range). I used a date table that I keep as a date dim with week numbers assigned. I related the dates and then put the week number on my axis.