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.

 

FECHALast Day
Sunday, March 1, 20200
Monday, March 2, 20200
Tuesday, March 3, 20200
Wednesday, March 4, 20200
Thursday, March 5, 20200
Friday, March 6, 20200
Saturday, March 7, 20201
Sunday, March 8, 20200
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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi jsim100 

     

    You need a DAX calculated column?

     

     

    Last Day = IF( WEEKDAY(yourTable[Date])=7,1,0)

     

     

  • 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.