Forum Discussion
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...
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.
