I want to display the count of customers created in the last three months.

[Anonymous]

Date of creation column is there to do the calculation.

Please help me to do the same using Date Between, Date Add functions.

Please

Used the following formula, Insteasd of 90 days, I want to add month number

New Customer in Last 3 Months New =

CALCULATE( DISTINCTCOUNT(Sales[CustomerCode]),

DATESBETWEEN('Sales'[DateofOrder],

TODAY()-90,

TODAY()

))

[Anonymous]

Time-intelligence functions DO NOT WORK on date columns in tables that are not proper Date tables.

Please learn a bit about these functions and how to correctly handle time in PBI models (date/time dimensions).

Best
Darek

[Anonymous]

Already created calendar table manually. And defined relationship between calendar date column and customer creation date column. So it will work right?

[Anonymous]

Instead of writing

New Customer in Last 3 Months New =
CALCULATE( DISTINCTCOUNT(Sales[CustomerCode]),
    DATESBETWEEN('Sales'[DateofOrder],
    TODAY()-90,
    TODAY()
    )
)

you should use the Date table

New Customer in Last 3 Months New =
var __today = TODAY()
var __90DaysBackFromToday = TODAY() - 90 + 1 -- yes, you have to add 1
var output =
CALCULATE (
    DISTINCTCOUNT( Sales[CustomerCode] ),
    DATESBETWEEN (
        'Dates'[Date],
        __90DaysBackFromToday,
        __today
    )
)

Best

Darek