Last day columns over a date column with Values

[ADCOPBI]

I have a date column that has corresponding values. Instead of just seeing all of the dates or just one date. I want to know if there is a way where across the whole column it only takes every month's last date. So for example If my data has September 1 - December 31st I only want to see the last dates in one table for those months. 

[Anonymous · Accepted solution]

Hi @ADCOPBI ,

Based on your description, you can create a measure as follows.

Measure =

var x1=ENDOFMONTH('Table'[Date])

return

IF(MAX('Table'[Date])=x1,1,0)

Result:

Hope that's what you were looking for.

Best Regards,

Yuna

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

[littlemojopuppy]

Yes.  Add a transformation step in Power Query using the Date.EndOfMonth function