displaying count of sales by two different dates

[Anonymous]

I've a table sales like

idcustomer	year of birth	amount	salesdate	next processingdate	new processingdate
12	1970	120	12/03/2022	15/04/2022	17/03/2022
13	1975	140	13/03/2022	18/04/2022	23/03/2022
14	1980	160	14/03/2022	21/04/2022	29/03/2022
15	1985	180	15/03/2022	24/04/2022	04/04/2022

there are 2 columns New_processing_date and next_processing_date that I need a timeline how many of sales that it is each day 

Something like this but I dont think I got it right, how to correct it please?

[AilleryO · Accepted solution]

Hi,

My advice would be to use a date table (easy and quick to build, like this) and make a relationship with your Sales date. Then make a second relation from New Processing date and your date table.

This 2nd relationship will be inactive (dashed line), but to use that relation use the function USERELATIONSHIP.

I don't know your structure but it will be something like this :

To SUM using the sales date and building your table with date coming from date table :

SUM( [Salesamount] )

or for SUM using the NewProcessingDate :

CALCULATE( SUM( [Salesamount] ) , USERELATIONSHIP( [NewProcessingDate] , DateTable[Date] ) )

Both calculations in a visual using date from date table should give you expected results.

Let us know