Latest Day Column

[thampton]

I have a calendar table that generates from oct 1 2019 to current day. 

Is there a formula i could write to add a column showing the latest date in each month (0/1 values). For example, column would have a 1 on oct 31, 1 on nov 30, etc. but also have a 1 on feb 14, then tomorrow it would move to feb 15, etc...

Thanks

[MFelix · Accepted solution]

Hi @thampton ,

Try the following calculated column:

Column =
SWITCH (
    TRUE ();
    'Calendar'[Date] = EOMONTH ( 'Calendar'[Date]; 0 )
        || 'Calendar'[Date] = TODAY (); 1;
    0
)

[thampton]

@MFelix  This worked perfectly! Thank you so much.

[amitchandak]

Try Like a new column like

Column =

var _max= maxx(date,date[date])

Return

if(date[date]=eomonth(date[date]) || date[date] =_max,1,0)

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin