Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Syndicate_Admin
Administrator
Administrator

Recuento distinto con varios criterios Si el valor IF existe en una columna

Necesito distintos ID de conteo,

SI entre las fechas seleccionadas contienen( [Contar],1) ; ENTONCES los meses activos > = 11 y la bandera = y, parece que necesito un filtro anidado o algo similar el recuento de beuase = 1 no se alinea con los meses activos y la bandera, por lo que este ID se elimina del recuento total.

Esto es lo que escribí:

var _Max_Date = MAX('Calendar Service'[Date])
VAR _ENR_DATE = EOMONTH(_Max_Date,-2)+1
var _Max_12_MOS = date(year(_Max_Date),Month(_Max_Date)-11,1)
VAR _gpnb = MAX(LIST[GP])

VAR _ID = GROUPBY(FILTER('Table',[Start_Date] >= _ENR_DATE &&  [Start_Date] <= _Max_Date && [GP]=_gpnb), [ID] )

RETURN
SUMX(  CALCULATETABLE(SUMMARIZE('Table',[GP],[ID],
    "_Count",SUMX(VALUES(Table,[ID]),1)),FILTER('Table',[GP]=_gpnb 
    && [ID] IN _ID && ([Start_Date] >= _Max_12_MOS &&  [Start_Date] <= _Max_Date) 
    && [FLAG] = "Y" && [Active_months] >= 11)),
_COUNT)
GPIDENTIFICACIÓNCONTARStart_DateActive__monthsBANDERA
94212003/01/202212Y
94212002/01/202212Y
94212001/01/202212Y
94212012/01/202111Y
94212111/01/202110N
94212010/01/20219N
94212009/01/20218N
94212008/01/20217N
94212007/01/20216N
94212006/01/20215N
94212005/01/20214N
94212004/01/20213N
0 REPLIES 0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.