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.
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?
User | Count |
---|---|
41 | |
29 | |
22 | |
20 | |
15 |