Also help me out with the logic on how to get the all associated weekNumbers for the particular month in a Year.
Jan - 2019 01.2019
Jan - 2019 02.2019
Jan - 2019 03.2019
Jan - 2019 04.2019
Thanks in advance.
Just an FYI, but it's probably better to post these kind of questions on the Designer Discussions board as you're much more likely to get a quick response as there are so many more people on those boards compared to the London User Group Board.
To answer your requests, you will need to think about how you want to do this as a Month does not map perfectly to a week number, so it's not as simple and turning to a date and then doing a join. If you want to do the join based on the week number of the first week in that month then you can covert to a week number using this formula:
These posts might also be of interest to you: