Forum Discussion
Solved
Last day columns over a date column with Values
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'...
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.
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.