Forum Discussion

joaquinel's avatar
joaquinel
Icon for Helper I rankHelper I
3 years ago

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

 

 

 

 

No RepliesBe the first to reply