Issue using isonorafter () and a Date Var

[Anonymous]

Hello guys!.

Im trying to plot an accumulative sum based on the last date entered in a DateField Box. My plot has to show all the months of the current selected year (for example: if i pick 01-jun-20 on the second DateFieldBox ... the plot has to go from 01-jan-20 to 31-dec-20). 

I tried this code but it doesnt work as i expect.
01andres =

VAR month =

MONTH ( MAX ( 'Calendario'[Fecha] ) )

VAR year =

YEAR ( MAX ( 'Calendario'[Fecha] ) )

VAR last1 =

DATE ( year, 12, 31 )

VAR first1 =

DATE ( year, 1, 1 )

RETURN

CALCULATE(

    COUNTA('Tareas'[Tare_Fech_Prog]),

    FILTER(

        ALLSELECTED('Calendario'[Fecha]),

        ISONORAFTER('Calendario'[Fecha],last1, DESC,'Calendario'[Fecha],first1, ASC)

    )

)

When i use Max(), it works but it shows the values between the DateFilde box range entered and i dont want it.

What should i do?.

Thank youu!!

[v-cazheng-msft]

Hi, @Anonymous 

This is a video about the usage of the ISONORAFTER function. For your first formula, the usage of this function maybe a little bit wrong and only the first half of the parameters work. In addition, is there only data from 16-April-2020 to 31-December-2021 in your table?

Best Regards,

Caiyun Zheng

[Anonymous]

Hi @v-cazheng-msft ,

No, I have data from 2019 to 2024

[v-cazheng-msft]

Hi, @Anonymous 

Is DateFieldBox in your report a Slicer? Can you provide a sample removing sensitive data and describe your report with more details?

Best Regards

Caiyun Zheng

[Anonymous]

Hi @v-cazheng-msft , thanks for your help.

pbi file:
https://drive.google.com/file/d/1Y47QDmcawQ7x2BQOsarrAurGbsSs7IPJ/view?usp=sharing

i want to do an accumulative sum with "programed" and "executed" dates (watch "tareas" table).
The year of my second input in DateFieldBox decides the plot range. If I select 13-06-2020 and 18-09-2020, i have to do an acumulative sum from 01-01-2020 to 31-12-2020.

Isonorafter isnt working with Var = Date() ... only works with max(date).

[v-cazheng-msft]

Hi, @Anonymous 

Do the values in this figure you want? Can you describe the calculated logic of it?

Ive got a visual like the following figure, but the values in it different from the figure you provided. 

Best Regards,

Caiyun Zheng

[Anonymous]

Hello @v-cazheng-msft ,

My 2020 plot is ok except in the part it shows from april.

The logic is that january is only january ... february is equal to january + february .... so december = december + november + october + ...... january.

I think your figure is showing regardless of the year entered

[amitchandak]

@Anonymous , Try a measure like

Cumm =
var _max = maxx(allselected('Date'), 'Date'[Date])
return
CALCULATE(COUNTA('Tareas'[Tare_Fech_Prog]),filter(all('Date'),'Date'[Date] <=max('Date'[Date]) && year('Date'[Date]) = _max))

[Anonymous]

Hi @amitchandak , thank you for your reply!

I did it but it shows nothing.