Flag the last date of the month for extract date

[BigKev]

Hi All,

I have multiple extract date in one month on my data set.

For my monthly reporting, I just need to pick the last extract date of every extract the month. How can I create a flag to only pick the last extract date of a month?

Thanks.

Cheers,

Kev

[Tahreem24]

@BigKev ,

Create DAX like below:

Flag = If(Table[ExtractDate]=MAX(Table[ExtractDate]),1,0)

[BigKev]

HI Tahreem24,

Thank you for the prompt response.

The Dax queries only give me the flag on the latest date, which  is 12/10/20.

I need to have flag '1' on the last date for every extract month, as per in the port scr.

Cheers,

Kev

[Tahreem24 · Accepted solution]

@BigKev ,

Just change the DAX like below:

Flag = If(Table[ExtractDate]=ENDOFMONTH(Table[ExtractDate]),1,0)