Date from week and year

[alexcatala]

Hi,

I am currently working with a table, which provides year and week, but I would like to have a date (DD/MM/YYYY). As I need it to make some relationship.

Any suggestion in how to calculate the date from year and week num?

Thanks for your time

[amitchandak · Accepted solution]

@alexcatala , You can get week start date like

Week to Date = var _st = date([year],1,1)
var _week = [Week]
Return _st+((_week-1)*7) -WEEKDAY(_st,2)+1

Format of date can be set under format or you set at the system level

https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/...

Date as text = format([Week to Date],"dd/mm/yyyy")

[alexcatala]

@amitchandak That works!! Thanks