Help using secondary relationship and previous month

[Anonymous]

Hello!

I don't understand why my measure isn't working.

I need to show my client how he did in relation to the previous month, the visualization will show the entire year.

I only had a text column with the name of the month, so I created a column that shows the date like the first day of the month to create the relationship between my date table and this table.

My measure must be wrong somewhere because it shows 100% for everything, when 01/10/2019 should show -2% and so on.

% OK =

DIVIDE(

               [Total ok]

             , [Total]

)

Variation =

VAR PREVIOUS_MONTH =

          CALCULATE(

                                  [% OK]

                                  , PREVIOUSMONTH('d_Calendário'[Data])

           )

VAR CURRENT_MONTH = [% OK]

VAR DIFF = CURRENT_MONTH - PREVIOUS_MONTH

              RETURN

              DIVIDE(

                             DIFF

                             ,  CURRENT_MONTH

)+0

Variation | % OK | Month

can anyone help me?

[amitchandak]

@Anonymous , This seem like correct formula , make sure this (d_Calendário) is a date table and also marked as date table , right click mark as date table