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.