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
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

August Community Highlights

Check out a full recap of the month!

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

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.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors