Hi I need some help, This is my line for filt...

Hi I need some help, This is my line for filtering Rows: OR(IN(USEREMAIL(),Data[Admins]), USEREMAIL() = [Email]) How I can add another condition that only show to the users data of the actual Month? I have a column in my data that show Month

Thanks in advance.

0 6 263
6 REPLIES 6

How aboutโ€ฆ AND(OR(IN(USEREMAIL(),Data[Admins]),USEREMAIL() = [Email]),[Month]=MONTH(TODAY()))

@Aleksi_Alkio Thanks that help, But I did This AND(OR(IN(USEREMAIL(),Data[Admins]),USEREMAIL() = [Email]), MONTH([Month])=02) I will have to change the number every month but thats fine for me

May I ask why do you need to change it?

How aboutโ€ฆ AND(OR(IN(USEREMAIL(),Data[Admins]),USEREMAIL() = [Email]),[Month]=MONTH(TODAY()))

@Aleksi_Alkio Thanks that help, But I did This AND(OR(IN(USEREMAIL(),Data[Admins]),USEREMAIL() = [Email]), MONTH([Month])=02) I will have to change the number every month but thats fine for me

May I ask why do you need to change it?

Top Labels in this Space