Create new calculated table by date range

Hi, jdubs 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

If you want to create two calculated columns, you may try the following dax.

Table 1 = 
FILTER(
    'Table',
    YEAR('Table'[Date])=YEAR(TODAY())&&
    MONTH('Table'[Date])<MONTH(TODAY())&&
    MONTH('Table'[Date])>=MONTH(TODAY())-6
)

Table 2 = 
FILTER(
    'Table',
    YEAR('Table'[Date])=YEAR(TODAY())-1&&
    MONTH('Table'[Date])<MONTH(TODAY())&&
    MONTH('Table'[Date])>=MONTH(TODAY())-6
)

If you want to create two measures, you may try dax as below.

Count This Year = 
COUNTROWS(
    FILTER(
        ALL('Table'),
        YEAR('Table'[Date])=YEAR(TODAY())&&
        MONTH('Table'[Date])<MONTH(TODAY())&&
        MONTH('Table'[Date])>=MONTH(TODAY())-6
    )
)

Count Last Year = 
COUNTROWS(
    FILTER(
        ALL('Table'),
        YEAR('Table'[Date])=YEAR(TODAY())-1&&
        MONTH('Table'[Date])<MONTH(TODAY())&&
        MONTH('Table'[Date])>=MONTH(TODAY())-6
    )
)

Result:

Best Regards

Allan

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