cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Noblelox
Resolver I
Resolver I

Can you make = Date.WeekOfYear([Date Complete]) start in April for the UK tax year?

As in the title...

I an using = Date.WeekOfYear([Date Field]) to create a custom column so I can do a weekly report. However, I want to start at 1st April, not 1st January. Is it possible to change the result, or when it comes to filtering in a Visualisation?

Second question would be how do I filter to just show this calendar week?

3 REPLIES 3
V-pazhen-msft
Community Support
Community Support

@Noblelox 

You can create a custom calendar referring to this blog:

Create a Custom Period Calendar in Power Query - Microsoft Power BI Community

 


Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

watkinnc
Responsive Resident
Responsive Resident

Try Date.WeekOfYear([Date Field])-Date.WeekOfYear(#date(Year.From([Date Field]), 4,1)+1

 

--Nate

lbendlin
Super User III
Super User III

I would (strongly) recommend that you use an external calendar table for fiscal years.  This can be a table in SQL server, or in Excel.  Don't try to do it in Power BI, you will regret it.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors