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

(José Baena) #1

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.

(Aleksi Alkio) #2

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

(José Baena) #3

@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

(Aleksi Alkio) #4

May I ask why do you need to change it?

(Aleksi Alkio) #5

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

(José Baena) #6

@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

(Aleksi Alkio) #7

May I ask why do you need to change it?