Forum Discussion

ADCOPBI's avatar
ADCOPBI
Frequent Visitor
5 years ago
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'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. 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.