Line Graphs Accumulated and empty when date < today

[Anonymous]

Hi guys, I made a line graph with 3 mesures: Planned Date, Projected Date and Real date. Both the mesures has the same dax code, just switching the date fields.

The code I used below is to accumulated the count from a previews date with the formula MAX: 

Teste Acumulado Real = CALCULATE([Contagem Tarefas Real];FILTER(ALLSELECTED(dCalendario);dCalendario[Datas]<=MAX(dCalendario[Datas]))

What I need is when the date is < today show an empty result for that month (year and so on..)

That's the graph I m building: https://imge.to/i/g97Ur

In short I want only the red line to stop in june because that's today's date.

Thank you.

[Ashish_Mathur]

Hi,

Try this measure

Teste Acumulado Real=IF(MAX(dCalendario[Datas])>=TODAY ();BLANK ();CALCULATE([Contagem Tarefas Real];DATESBETWEEN(dCalendario[Datas];MINX(ALL(dCalendario),dCalendario[Datas]);MAX( dCalendario[Datas]))))

[MFelix · Accepted solution]

Hi @Anonymous ,

Try to change your measure to the following:

Teste Acumulado Real =
IF (
    MAX ( dCalendario[Datas] ) >= TODAY ();
    BLANK ();
    CALCULATE (
        [Contagem Tarefas Real];
        FILTER (
            ALLSELECTED ( dCalendario );
            dCalendario[Datas] <= MAX ( dCalendario[Datas] )
        )
    )
)

Regards,

MFelix

[Anonymous]

Thank you, I tried to do the if statment inside the filter code but it didn't work.