Filter by first x days per group

[Anonymous]

My question is, is there a way to get the first/earliest date per grouping in a table and then filter the table to only include rows within the first x number of months of that first date, per grouping. Probably easiest to ask with example. Say I have the following table, and want to keep data for first 6 months of each Group:

The resulting table would look like:

Is there a way to do this using DAX/M?

[LivioLanzo · Accepted solution]

Hello @Anonymous

try like this:

FILTER(
    'Table',
    EDATE( [Date], -6 ) <=   CALCULATE( MIN( 'Table'[Date] ), ALLEXCEPT( 'Table', 'Table'[Group] ) )
)

[Anonymous]

@LivioLanzothanks for your response. Where would I actually enter this code? Can you possibly provide PBIX file example?

[LivioLanzo]

@Anonymous

It is a DAX query which returns a table so you'd go to the 'Modeling' tab and click on 'New Table'