Forum Discussion

MH3's avatar
MH3
Helper V
4 years ago
Solved

Getting Date from Week Number and Year

 Hi, I have a fact table in which I have Week Number and Year wise Sales I want to create a relationship of fact table with my calendar Table (Which have all dates from Year 2020 and 2021...
Show and Tell
Tips and Tricks
  • Syndicate_Admin's avatar
    Syndicate_Admin
    4 years ago

    It's working well 🙂

MH3's avatar
MH3
Helper V
4 years ago

Actually, The data was given on Week-Year basis

so I had splitted the week and year

= (TheYear as number, TheWeek as number) as date =>
let
//test
//TheYear = 2018,
//TheWeek = 1,
//
offsetToISO = Date.AddDays(#date(TheYear,1,1),-4),
dayOfWeek = Date.DayOfWeek(offsetToISO, Day.Monday),
offset = -dayOfWeek + (TheWeek * 7),
isoWeekDate = Date.AddDays(offsetToISO, offset)
in
isoWeekDate


and the StartWeek I had calculated by this Function 

TomMartens's avatar
TomMartens
Super User
4 years ago

Hey MH3 ,

 

please take the time and create a pbix that contains sample data, including your M functions. Upload the pbix to onedrive or dropbox and share the link.

 

Regards,

Tom

  • MH3's avatar
    MH3
    Helper V
    4 years ago

    TomMartens  I have sent you a private message kindly go through it.