Forum Discussion

jsim100's avatar
jsim100
Frequent Visitor
5 years ago
Solved

Last Day

Hi. I have a dates column. I need a dax formula that indicates the last day with an 1 and when this day is Sunday, that day doesnt count.  Thanks.   FECHA Last Day Sunday, March 1, 2020 0...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi jsim100 

     

    Try this code to add a column

     

    Last Day = 
VAR __lastday = MAXX(FILTER('Table',WEEKDAY('Table'[Date],2)<7),'Table'[Date])
RETURN
IF('Table'[Date] = __lastday,1,0)

     

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi jsim100 

 

Try this code to add a column

 

Last Day = 
VAR __lastday = MAXX(FILTER('Table',WEEKDAY('Table'[Date],2)<7),'Table'[Date])
RETURN
IF('Table'[Date] = __lastday,1,0)

 

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.