Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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?

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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

     

    --Nate