Calculation for a last month metric

[Anonymous]

How do I calculate a metric which is the following for the last month.

What I have does not work:

this table 'time to conversion is connected to 'dim_date[Date]

% one session conversions = 
CALCULATE(
    COUNT('time_to conversion'[user_pseudo_id]),
    'time_to conversion'[Session To Conversion Band] = "1"
)
/ DISTINCTCOUNT('time_to conversion'[user_pseudo_id])

[vojtechsima · Accepted solution]

Hello, @Anonymous ,

it depends on how you define last month but, if you have a calendar with some flag or just have Slicer.
you can do something like this.

% one session conversions = 
CALCULATE(
CALCULATE(
    COUNT('time_to conversion'[user_pseudo_id]),
    'time_to conversion'[Session To Conversion Band] = "1"
)
/ DISTINCTCOUNT('time_to conversion'[user_pseudo_id]),
'calendar'[YearMonth]=MAX('calendar'[YearMonth])
)

alternatively using TOTALMTD

% one session conversions = 
TOTALMTD(CALCULATE(
    COUNT('time_to conversion'[user_pseudo_id]),
    'time_to conversion'[Session To Conversion Band] = "1"
)
/ DISTINCTCOUNT('time_to conversion'[user_pseudo_id]), 'calendar'[Date])

or datesmtd

% one session conversions = 
CALCULATE(
CALCULATE(
    COUNT('time_to conversion'[user_pseudo_id]),
    'time_to conversion'[Session To Conversion Band] = "1"
)
/ DISTINCTCOUNT('time_to conversion'[user_pseudo_id]),
DATESMTD('calendar'[Date]) )