Last Day

[jsim100]

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
Monday, March 2, 2020	0
Tuesday, March 3, 2020	0
Wednesday, March 4, 2020	0
Thursday, March 5, 2020	0
Friday, March 6, 2020	0
Saturday, March 7, 2020	1
Sunday, March 8, 2020	0

[v-jingzhang · Accepted solution]

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.

[Anonymous]

Hi @jsim100 

You need a DAX calculated column?

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