DAX - How to introduce dcalendar on the x axis of a measure chart?

[Diego_Vialle]

I have two measures for the sum of customers who NEVER PURCHASED, BUT PURCHASED in the last three months. How do I insert the dcalendar table on the "x" axis to have the period shown in the chart?

When entering the dcalendar, the values are different from those calculated by the measurements. Follow the measures below:

Measure for current customers:

Novos Clientes Trimestrais =

VAR AllOldCustomers =

CALCULATETABLE (VALUES ( SBOPRODMS[Nome do PN] ),

SBOPRODMS,

SBOPRODMS[Data NF] < TODAY () - 90,

SBOPRODMS[Documento] = "Nota fiscal de saída"

)

VAR AllNewCustomers =

CALCULATETABLE (VALUES ( SBOPRODMS[Nome do PN] ),

SBOPRODMS[Data NF] < TODAY () ,

SBOPRODMS[Documento] = "Nota fiscal de saída"

)

RETURN

IF(ISBLANK((COUNTROWS ( EXCEPT (AllNewCustomers, AllOldCustomers )))),0,COUNTROWS ( EXCEPT (AllNewCustomers, AllOldCustomers )))

Measure for customers from the previous period:

Novos Clientes Trimestrais PY =

     VAR PreviousYearDate = DATE ( YEAR ( TODAY () ) - 1, MONTH ( TODAY () ), DAY ( TODAY () ) )

        VAR AllOldCustomers = CALCULATETABLE ( VALUES ( SBOPRODMS[Nome do PN] ),

        SBOPRODMS, SBOPRODMS[Data NF] < PreviousYearDate - 90,

        SBOPRODMS[Documento] = "Nota fiscal de saída" )

        VAR AllNewCustomers = CALCULATETABLE ( VALUES ( SBOPRODMS[Nome do PN] ),

        SBOPRODMS[Data NF] < PreviousYearDate,

        SBOPRODMS[Documento] = "Nota fiscal de saída" )

RETURN IF ( ISBLANK ( ( COUNTROWS ( EXCEPT ( AllNewCustomers, AllOldCustomers ) ) ) ), 0, COUNTROWS ( EXCEPT ( AllNewCustomers, AllOldCustomers ) ) )

[tamerj1]

Hi @Diego_Vialle 

have you tried with SBOPRODMS[Data NF] column? I guess further running total technique should be applied. 

[Diego_Vialle]

Hi @tamerj1 

Do you have any idea how I can solve this and use dCalendar?

[Diego_Vialle]

Yes, but using it is changing the value of measurements.