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.
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)
GP | IDENTIFICACIÓN | CONTAR | Start_Date | Active__months | BANDERA |
94 | 212 | 0 | 03/01/2022 | 12 | Y |
94 | 212 | 0 | 02/01/2022 | 12 | Y |
94 | 212 | 0 | 01/01/2022 | 12 | Y |
94 | 212 | 0 | 12/01/2021 | 11 | Y |
94 | 212 | 1 | 11/01/2021 | 10 | N |
94 | 212 | 0 | 10/01/2021 | 9 | N |
94 | 212 | 0 | 09/01/2021 | 8 | N |
94 | 212 | 0 | 08/01/2021 | 7 | N |
94 | 212 | 0 | 07/01/2021 | 6 | N |
94 | 212 | 0 | 06/01/2021 | 5 | N |
94 | 212 | 0 | 05/01/2021 | 4 | N |
94 | 212 | 0 | 04/01/2021 | 3 | N |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |