Forum Discussion
Matrix. Distribution of my data
It does not distribute the data amounts according to the day on which they occur (CollectionDate). The final data is correct, but it should/needs to be distributed by days. The distribution date is the Payments [FechaCobro].
The transactions I need are the ones where the receipt has Payments[FechaInicioValidez] within the range of Payments[FechaCobro], hence the DATESBETWEEN.
The Calendar is referenced to the FechaCobro, I have created a non-active relationship also with the FechaInicioValidez.
The formula is
CALCULATE
(
COUNT
(
Pagos[IdPersonaOrigen]
)
,
Pagos[CuentaContable] = "70810030"
,
USERELATIONSHIP('1CalFCobro'[Date], Pagos[FechaCobro])
,
Pagos[FechaCobro] <> BLANK()
,
DATESBETWEEN(
Pagos[FechaInicioValidez],
MIN(Pagos[FechaCobro]),
MAX(Pagos[FechaCobro])
)
)
as you can see de data is not distributed
matrix