Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
@Anonymous
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.
Try Date.WeekOfYear([Date Field])-Date.WeekOfYear(#date(Year.From([Date Field]), 4,1)+1
--Nate
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.