Hi..i have week number of the year and month number . Is it possible to extract Date from this

[Anonymous]

I have Week number of the year and Month number. So is it possible to make date out if these? Maybe week starting date or any possible date 

[v-shex-msft · Accepted solution]

Hi @Anonymous.,

You can check the below formula to get the week start date based on the year week number or compare a date value if it existed in the specific year week range.

WeekStart = 
MINX(
    FILTER (
        CALENDAR (
            DATE ( LEFT ( [YearWeekNum], 4 ), 1, 1 ),
            DATE ( LEFT ( [YearWeekNum], 4 ), 12, 31 )
        ),
        WEEKNUM ( [Date], 1 ) = VALUE ( RIGHT ( [YearWeekNum], 2 ) )
    ),
    [Date]
)

Within Range =
VAR weekRange =
    FILTER (
        CALENDAR (
            DATE ( LEFT ( Table[YearWeekNum], 4 ), 1, 1 ),
            DATE ( LEFT ( Table[YearWeekNum], 4 ), 12, 31 )
        ),
        WEEKNUM ( [Date], 1 ) = VALUE ( RIGHT ( Table[YearWeekNum], 2 ) )
    )
RETURN
    IF ( Table[Date] IN weekRange, "Y", "N" )

Regards,

Xiaoxin Sheng

[lbendlin]

Sure.... but you need to provide more details.  There are lots of different ways to count weeks in a year. Which year is it, what do you consider to be the first weekday, and what is the number of the first week?

Not sure what you would use the month number for?