cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shubhy04
Helper I
Helper I

DAX measure to get date from week number

Hi, 

 I am looking to create a measure that calculates week start/end date from week number. 

 

Ex: 

Week Number= 2

 Measure: 6th Jan'2020 (week start date) or 12th Jan'2020 (week end date)

 

Similary, another measure that calculates monrh start/end date from month number. 

Ex: 

Month Number= 3

 Measure: 1st Mar '2020 (month start date) or 31st Mar '2020 (month end date)

 

ANY help is appreciated. Thanks!!

1 ACCEPTED SOLUTION
az38
Super User
Super User

Hi @shubhy04 

have a look here https://community.powerbi.com/t5/Desktop/Obtain-Dates-from-Weeknumber/td-p/977680


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

1 REPLY 1
az38
Super User
Super User

Hi @shubhy04 

have a look here https://community.powerbi.com/t5/Desktop/Obtain-Dates-from-Weeknumber/td-p/977680


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!