Help to perform date filtering from 20 to 21

[Syndicate_Admin]

Hello hello, I wanted to ask for a little guidance to be able to make a filter that can give me the corresponding year but mainly that the month starts from the 20th of the previous month to the 21st of the month consulted, giving as an example that if today 21-05-2024 I require the information of January it gives me the data from 21-12-2023 to 20-01-2024, Thank you very much in advance

[newellaa · Accepted solution]

This one worked for me; 

Reporting Month = if(Dates[Day of Month] < 21, Dates[Month & Year], FORMAT(DATEADD(Dates[Date], 1, MONTH), "MMM YYYY"))

[ray_aramburo]

To not overcomplicate yourself, I would recommend just use the date field in a slicer, set it up as a Between type and input your dates:

[Syndicate_Admin]

I mean, I currently have it like this, the question is if there was something more friendly, like just selecting the month and having it perform the automatic conditioning

[ray_aramburo]

You wouldn't be able to use them as filters but you could create a pretty customized measure with time-intelligence and parameters. Something like:

DynamicMeasure = CALCULATE([WhateverExpressionYouWantToShow], DATESINPERIOD('DateTable'[Date], TODAY(),[ParameterField], MONTH))

[Syndicate_Admin]

If it really works for me, I ended up doing the following:

I made a start date

FiscalMonthStart =

IF(

(('DateTable'[Day]) >= 21), EOMONTH([Date],-1),EOMONTH([Date],-2)) +21

and another term

FiscalMonthEnd =

IF(

DAY('DateTable'[Date]) >= 21,

EOMONTH('DateTable'[Date], 0) + 20,

EOMONTH('DateTable'[Date], -1) + 20

)

Uniting it in

FiscalMonthName =

FORMAT('DateTable'[FiscalMonthEnd], "MMMM YYYY")

And then separating the information and then using what he mentioned to me

And it was finally like this

Thank you very much for your help