power bi dax group months into 2 month increments

[mcornfield]

Hello,

I have a date table and I am trying to create a column that breaks the dates up into 2 month periods so 

Jan-Feb

Mar-Apr

May-Jun

Jul-Aug

Sep-Oct

Nov-Dec

I only see how to do this with Month, Qtr, Week 

[v-rongtiep-msft · Accepted solution]

Hi @mcornfield ,

Please have a try.

First, create a column.

Column = QUOTIENT('Table'[date].[MonthNo]+1,2)

Then create a measure.

sum_ = CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),'Table'[Column]=SELECTEDVALUE('Table'[Column])))

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@mcornfield , You can 2 month period like

new columns

2 month period = Quotient(Month([Date])+1)

Year Period  = Year([Date])*100 + [2 month period]

Period Rank = RANKX(all(Period),Period[year period],,ASC,Dense)

Then you can have measures
This Period = CALCULATE(sum('Table'[Qty]), FILTER(ALL(Period),Period[Period Rank]=max(Period[Period Rank])))
Last Period = CALCULATE(sum('Table'[Qty]), FILTER(ALL(Period),Period[Period Rank]=max(Period[Period Rank])-1))

[mcornfield]

Thanks! are you sure you meant to use Quotient I think that's a division?

https://docs.microsoft.com/en-us/dax/quotient-function-dax