Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago
Solved

Help to perform date filtering from 20 to 21

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...
  • newellaa's avatar
    newellaa
    2 years ago

    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's avatar
ray_aramburo
Icon for Super User rankSuper User
2 years ago

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's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

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