You need to elaborate more what do you want to display and how the data look like and from where they are coming.
Are the logic refers to calendar-dates the above will in general work and might just need a few adjustments, for example for the current month which might be done with another condition querying the date against today().
If the logic relates to working-days they might be created at first within another flag-field which is afterwards accumulated and to max() aggregated and re-joined and in the next step a querying like above shown of date against max-date will return the MonthendFlag.
Should it relate to existing records within the facts you will need an aggregation logic like above suggested from @Kushal_Chawda whereby I wouldn't tend to join them back else applying it within a mapping to be able to set a zero as default value for the non-matching records.
In each case I suggest to do the work within the script by creating appropriate flag-fields and not in UI by applying it within complex set analysis conditions and/or further aggr() constructs if various dimensions needs to be considered.
