cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fguijarrob
Frequent Visitor

FILTER con varias condiciones de diferentes tablas

Buenos días,

Necesitaría añadir varias condiciones en un FILTER de diferentes tablas, concretamente:

 

 

Altas Lineas =
    CALCULATE(
         COUNT(Telef[lineadetelefono]),
          FILTER(
Telef,
Telef[fecha_inserccion] <= MAX('Calendario'[Fecha]) &&
OR (Telef[fecha_baja] > MAX('Calendario'[Fecha]), OR (ltelefonia[fecha_baja] = BLANK(), ISBLANK(Telef[fecha_baja])))&&
(ALL(Calendario), (Calendario[Fecha].[Año]=SELECTEDVALUE(Calendario[Fecha].[Año]) && Calendario[Mes Num]=SELECTEDVALUE(Calendario[Mes Num])-1))))
 
Gracias por la ayuda

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

1 REPLY 1
amitchandak
Super User
Super User

@fguijarrob , I think you need somthing similar to HR blog

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

 

You can check the files attached too

Helpful resources

Announcements
Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.