Datepicker only by months

[a10703ant]

Hi guys,

I hope you are doing well,

I have two date pickers range for filter my table of data .

Function: Today()

And have the filter 

Sum (
Filter('NAMEOFMYLISTS',
DATA >= datainicio.SelectedDate && DATA <= datafim.SelectedDate),
Value('NAME OF COLLUMN')

)

I create one dropdown with months but i can't filter the table....

How can i change this date picker or add one new with only months filter?

Thank you for all support !

[StalinPonnusamy]

Hi @a10703ant 

I suggest having one dropdown and 2 date control that you have now.

Filter Data Based on Selection. I have blog post similar to this. Please refer and let me know if any questions.

Thanks,
Stalin - Learn To Illuminate

[a10703ant]

I need all months , january, february, march etc...

[StalinPonnusamy · Accepted solution]

Hi @a10703ant 

Let me know if this solves your requirement in terms of UI

Set the items property of Month Dropdown to

Sequence(12)

Set the Items property of Year dropdown to

Sequence(25,2020)

Let me know, I can help to filter the data if this UI works for you.

Thanks,
Stalin - Learn To Illuminate

[v-qiaqi-msft · Accepted solution]

Hi @a10703ant,

Do you want to filter the data based on month only and sum a column based on the filtered result?

Could you please tell me if the DATA column is a Date and time column in SP list?

If it is a Date and time column in your SP list, please keep your DatePicker and modify your formula as below:

Sum (
Filter('NAMEOFMYLISTS',
Month(DATA) >= Month(datainicio.SelectedDate) && Month(DATA) <= Month(datafim.SelectedDate)),
Value('NAME OF COLLUMN')

)

Use the Month() function to extract the month number from the date.

[a10703ant]

Thank you for all help