Filter Enum Slice

[Yeyo1976]

I have two tables: Alumnos and Bitacora Diaria. The Bitacora Diaria table is referenced with Alumnos through an enum to a slice that has this expression:

and(([Correo Profesora] = USERSETTINGS("User Email")),
([Estado Alumno] = "Active"))

Now, when selecting students to generate the report "Bitacora del dia", the enum with the students associated with the teacher opens, but I need to show the associated students who do not have their "Bitacora del dia" done today.

For example, two of these four students already have a record today, and I don't need to see in the enum list when I want to create a new one.

Thansk!

[Kirk_Masden]

I may be misunderstanding your situation but my guess would be that you need to make another slice with your additional condition, something like:

and(([Correo Profesora] = USERSETTINGS("User Email")),([Estado Alumno] = "Active"),[Bitacora del dia] = "Not done")

In your case, I'm not sure if this should be a separate slice or a modification to a slice you already have but I'm pretty sure that the answer involves a slice with the appropriate conditions.

P.S. An additional condition may be necessary to distinguish between previous Bitacora del dia entries and the most recent one (the one for today).  That depends on your data and how it is structured. 

[Yeyo1976]

Hi, thanks for the answer.

---

[AleksiAlkio]

One way is to filter rows with the formula in valid_if because you can do it with the Ref column as well.

[Yeyo1976]

Hi, how can I do that?

[AleksiAlkio · Accepted solution]

Something like this should work..

RefTable[KeyColumn] - IFS(NOT(IN([KeyColumn],Table[KeyColumn])),SELECT(Table[RefColumn],[Created]=TODAY()))