Count number of days from past and future dates and then assign factor to sales number

[billuran0912]

Hello, I have a sales pipeline and I want to calcuate the age of the account from when it starts for each month of 2024. 

Sales table

Account	StartDate	Sales
abc	2/5/24	10000

Date Table

Date	MonthYear
1/10/24	1/1/24

So for every month on a matrix table it will show the difference from the Startdate to the Date in the month. I want to then aggregate those sales numbers and say if the the age of each account is over 30 days multiply sales for each account by 50% if less then 30 multiply 10%. I have more buckets but can add those later. Hope this is clear

[Anonymous]

Hi @billuran0912 

Just as @ryan_mayu , I've read once and once again, I haven't understand what is your expected outcome.

But as your description, maybe datediff() function can help you.

Here for your reference:

DATEDIFF function (DAX) - DAX | Microsoft Learn

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

not clear about this. pls provide more sample data and the expected output.