How do i remove the last date of a month?

[ShelRose]

Hi all, i'm new to PBI. 

I need to remove data from my query if that data has a leaving date of last day of the month? what measure would be best for this? 

I have been removing these manually from my report then uploading it to my BI desktop but i no longer want to do this? 

thanks in advance 

[Ahmedx · Accepted solution]

you need to do this in power query

[Smalfly]

Hi @ShelRose ,

power BI has a EOMPNTH function to obtain the last day of the month.

That might be helpfull for your case. Please check this article for more information on it.