Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II
Helper II

Create a biweekly/fortnighly column

Hi all, I am having trouble trying to create a biweekly/fortnightly column for a date slicer that resets itself back to "Fortnight 1". 

I want it to work similar to how the weeknum works, and it resets the fortnight back to first fortnight number after "Fortnight 26". 

Any help would be appreciated



Super User
Super User

@Anon29 , Create week start date


Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)


Year Week Start date =

var _date = date([year]),1,1)


_date +-1*WEEKDAY(_date ,2)+1 


Bi Week number =

quotient(datediff([Year Week Start date], [Week Start date], day),14) + 1


Bi Week Start Date=

[Year Week Start date] * 14 ([Bi Week number]-1)


For this vs last follow rank as week


Power BI — Week on Week and WTD

Thanks for your help @amitchandak but this variable keeps giving me an error saying incorrect syntax.

var _date = date([year]),1,1)

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.