I have new column/Measures for below column name "Wk_num".
Date [Date_GHY] extract wk num and Yr for DAX/Power Query .
Go to Solution.
what is the problem? if you need "Wk_num" column try
CONCATENATE("Wk_", CONCATENATE(WEEKNUM('Date'[Date_GHY]), CONCATENATE("_", YEAR('Date'[Date_GHY])))
View solution in original post
Week Number = Week = "Wk_" & WEEKNUM([Date],2) & "_" & format('Date',"YYYY" )
Week Number = Week = "Wk_" & WEEKNUM([Date]) & "_" & format('Date',"YYYY" )
Proud to be a Super User!
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.