Forum Discussion

thampton's avatar
thampton
Helper III
6 years ago
Solved

Latest Day Column

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 wo...
General Comment
Need Help
Show and Tell
  • MFelix's avatar
    MFelix
    6 years ago

    Hi thampton ,

     

    Try the following calculated column:

     

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

     

MFelix's avatar
MFelix
Super User
6 years ago

Hi thampton ,

 

Try the following calculated column:

 

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

 

thampton's avatar
thampton
Helper III
6 years ago

MFelix  This worked perfectly! Thank you so much.