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]

Already created calendar table manually. Relationship also defined. Can I proceed with this approach? 

[Anonymous]

You should be able to. Assuming your calendar is set up correctly. Just in your measure use the columns from the data table for the dates and not the column from your sales table for the dates. Give it a shot and if you still have issues or questions upload some sample data and I can take a look. 

[Anonymous]

First thing you want to do is create a dedicated calendar table, set it as a date  table, and then use the columns from that table. Then you can use the time intelligence functions correctly.