Slice that only show rows of the current month

[AnshulKamboj]

Hi All,

Please help to make a slice that show the data fallen within the current month

Start Date                End Date             Utilization Percentage
01-Feb-2022           28-Feb-2022                          20
3-Jan-2022             31-Dec-2022                           40
16-Feb-2022           15-Feb-2023                           80

The dates of the 2 & 3 rows are fallen in this month, so I want to make a slice that filter the data according to start Date and End Date Column.

It should exclude the date which has already gone.

@TeeSee1 , @Suvrutt_Gurjar 

[Aleksi]

Something like..

AND(
EOMONTH([Start Date])=EOMONTH(TODAY()),
EOMONTH([End Date])=EOMONTH(TODAY())
)

[AnshulKamboj]

It throws an error EOMONTH function is used incorrectly.

[Aleksi]

Sorry, my mistake 🙂

AND(
EOMONTH([Start Date],0)=EOMONTH(TODAY(),0),
EOMONTH([End Date],0)=EOMONTH(TODAY(),0)
)

[AnshulKamboj]

Please refer the attached Image It is excluding the row which falls in the current month

See the 2nd Row

[TeeSee1 · Accepted solution]

Try this...

AND(
 EOMONTH([Start Date],0) <= EOMONTH(TODAY(),0),
 EOMONTH(TODAY(),0) <= EOMONTH([End Date],0)
)

[AnshulKamboj]

Thank You