Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter with datesinperiod function

Hi,   I have this DAX: #Eventos 12 meses atras = CALCULATE (         [#Eventos];         DATESINPERIOD(Semana[FECHA].[Date];LASTDATE('Eventos OW'[Fecha Fin Operación]);-12;MONTH)         ) ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi,

    I did not receive any response but I got the solution by my own:

     

    First I calculate the [#Eventos] by months using a column in the calendar table with YYYY-MM, then apply this DAX:

     

    #Eventos 12 meses atras =
    CALCULATE (
            [#Eventos];
            FILTER(ALL(Semana[FECHA].[Date]);LASTDATE('Eventos OW'[Fecha Fin Operación]));
            DATESINPERIOD(Semana[FECHA].[Date];LASTDATE('Eventos OW'[Fecha Fin Operación]);-12;MONTH)
            )
    Greetings
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous ,

#Eventos 12 meses atras =
CALCULATE (
        [#Eventos];
        DATESINPERIOD(Semana[FECHA].[Date];LASTDATE('Eventos OW'[Fecha Fin Operación]);-12;MONTH)
        )
 
But the 12 months calculation is affected by external filters, how can I solved this

 

What is the exteranl filter?

 

If it is convenient, could you share your data sample which could reproduce your scenario and your desired output so that we could help further on it.

 

Best  Regards,

Cherry