How to default the data in a table or visual based on the current day of the month

[AFoisAnalytics]

Hi all,

I need to filter the data shown in a table and in the charts of the report automatically at the opening, with this logic:

if today the month day is < 20, the report needs to show the data starting from the last day of 2 precedent month. So for example if Today is 18 of March the data should start from last day of January.

Instead, if today the month day is >= 20, the data shown should start from the last day of the past month. So if Today is 21 of March the data should start from last day of February.

How could I do this?  

Thank You 

[Anonymous · Accepted solution]

Hi  @AFoisAnalytics ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Flag =
var _today=TODAY()
var _day=DAY(_today)
return
 IF(
     _day>=20&&MAX('Table'[Date])>=EOMONTH(_today,-1),1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[lbendlin]

- add a calculated column to your calendar table that implements the required logic as needed (include/exclude)

- use that column as the default filter in your report but allow your users to change it.