Forum Discussion
Convert Months to weeks
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
To Anonymous's point, if you had a Date table like DateStream in the Azure Data Marketplace, you could relate your fact table to your date table on the actual date in the fact table (if it is there) and your date table should be able to tell you what week of the year that date falls on.
Yeah, that's pretty much what I'm trying to describe. You would never expose your actual date column in any visual on the report; you'd only put the Week column from the date table down, and the relationship between your table's date column and the date table's primary date column would do all the work for you.
I keep meaning to check out that DateStream table. My date table is an ok example, but it sure does load slowly. Too many calculated columns in the query I'm sure.
Anonymous here is the direct link to it:
http://datamarket.azure.com/dataset/boyanpenev/datestream
Free and you only need to download it once per data model.