Grouping Dates of a month as fortnights using Power Query/DAX measure column


I am working on some data and need to group my dates as fortnight. For e.g. 1st to 15th should be Fortnightly 1 and remaining dates should be fortnightly 2. This would be same for each month. I have a “SalesData” and “Calendar” in my powerpivot data model. Would appreciate early help. I wanted to do it in power query itself (since I have made a date table using power query) but i am not able to do it.

Thanks in advance.

Harish Rathore

To get the fortnight grouping, you just need the DayOfMonth column and then based on that add a custom column:

You can also do it with DAX by adding a calculated column:

Fortnight Grouping DAX =
‘Date’[DayOfMonth] <= 15,

Fortnight Grouping.pbix (42.7 KB)


Hi @harishrathore, did the response provided by @MudassirAli help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!

Thanks a lot for this. It has helped me a lot.

1 Like