cancel
Showing results for
Did you mean:
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 .

Thanks,

KV

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User VI

## Re: Date Wk and Yr Add

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
Highlighted
Super User IX

## Re: Date Wk and Yr Add

//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!

2 REPLIES 2
Highlighted
Super User VI

## Re: Date Wk and Yr Add

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
Highlighted
Super User IX

## Re: Date Wk and Yr Add

//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!

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

#### Get Ready for Power BI Dev Camp

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

Top Solution Authors
Top Kudoed Authors