Forum Discussion
The same Measure but distinct dates
- 8 years ago
With a isolated table for months, yo can do something like this:
VALOR_A_BUSCAR =
IF (
HASONEVALUE( Meses[Mes] );
VALUES( Meses[Mes] );
"ERROR"
)
Columna1 =
CALCULATE(
COUNTROWS( Facts );
FILTER(
Facts;
Facts[F.INI_PARTIDA]=[VALOR_A_BUSCAR]
)
)
Columna2 =
CALCULATE(
COUNTROWS( Facts );
FILTER(
Facts;
Facts[F.FIN_PARTIDA]=[VALOR_A_BUSCAR]
)
)
tell me if it's useful
With a isolated table for months, yo can do something like this:
VALOR_A_BUSCAR =
IF (
HASONEVALUE( Meses[Mes] );
VALUES( Meses[Mes] );
"ERROR"
)
Columna1 =
CALCULATE(
COUNTROWS( Facts );
FILTER(
Facts;
Facts[F.INI_PARTIDA]=[VALOR_A_BUSCAR]
)
)
Columna2 =
CALCULATE(
COUNTROWS( Facts );
FILTER(
Facts;
Facts[F.FIN_PARTIDA]=[VALOR_A_BUSCAR]
)
)
tell me if it's useful
Perfect.
Thank you very much.