Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
User | Count |
---|---|
77 | |
74 | |
60 | |
60 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |