cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Date Wk and Yr Add

Hi Team,

 

I have new column/Measures for below column name "Wk_num".

Date [Date_GHY] extract wk num and Yr for DAX/Power Query .

 

screen.PNG

 

Thanks,

KV

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User VI
Super User VI

Re: Date Wk and Yr Add

Hi @Kalidass 

what is the problem? if you need "Wk_num" column try

Wk_num = 
CONCATENATE("Wk_", CONCATENATE(WEEKNUM('Date'[Date_GHY]), CONCATENATE("_", YEAR('Date'[Date_GHY])))

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

View solution in original post

Highlighted
Super User IX
Super User IX

Re: Date Wk and Yr Add

@Kalidass ,

//Monday week

Week Number =
Week = "Wk_" & WEEKNUM([Date],2) & "_" & format('Date',"YYYY" )

//Sunday Week

Week Number =
Week = "Wk_" & WEEKNUM([Date]) & "_" & format('Date',"YYYY" )

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
Highlighted
Super User VI
Super User VI

Re: Date Wk and Yr Add

Hi @Kalidass 

what is the problem? if you need "Wk_num" column try

Wk_num = 
CONCATENATE("Wk_", CONCATENATE(WEEKNUM('Date'[Date_GHY]), CONCATENATE("_", YEAR('Date'[Date_GHY])))

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

View solution in original post

Highlighted
Super User IX
Super User IX

Re: Date Wk and Yr Add

@Kalidass ,

//Monday week

Week Number =
Week = "Wk_" & WEEKNUM([Date],2) & "_" & format('Date',"YYYY" )

//Sunday Week

Week Number =
Week = "Wk_" & WEEKNUM([Date]) & "_" & format('Date',"YYYY" )

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors