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

DAX DAX Calculations
1

Hi,

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.

Regards
Harish Rathore

2

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

1
11920×1080 173 KB
2
21920×1080 157 KB
3
31920×1080 171 KB

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

Fortnight Grouping DAX =
IF(
‘Date’[DayOfMonth] <= 15,
1,
2)

4
41920×1080 143 KB

Fortnight Grouping.pbix (42.7 KB)

2 Likes
3

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!

4

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

1 Like