topic Re: I want to display the count of customers created in the last three months. in DAX Commands and Tips

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

Anonymous — Sat, 10 Aug 2019 06:42:25 GMT

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()

))

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

Anonymous — Sun, 11 Aug 2019 19:22:18 GMT

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.

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

Anonymous — Mon, 12 Aug 2019 04:25:16 GMT

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

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

Anonymous — Mon, 12 Aug 2019 13:21:20 GMT

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.