Dynamic Column according to date selected

[Anonymous]

Hello guys,

I'm trying to calculate the amount of orders grouping by status in the selected date. I have a fact Sales, Calendar and a fact Historical Sales

fSales

id_order	sales date
ab123	01/01/19
ab124	02/01/19
ab125	02/01/19
ab126	03/01/19

fHistoricalSales

id_Order	DT_Status	Status
ab123	01/01/19	NOR
ab123	15/01/19	CAN
ab124	02/01/19	NOR
ab124	13/01/19	CAN
ab125	03/01/19	NOR
ab125	14/01/19	CAN
ab125	20/01/19	REC
ab126	05/01/19	NOR

I can count the Id orders if I get the last status order like following image. 

But I'd like when I select the range date like from 01/01/2019 to 13/01/2019 I get the status the orders were in that time, not the last status, like this:

Thanks!

[v-yuta-msft]

@Anonymous ,

Why the count value of 01/JAN with NOR is 1? Isn't it 2? Could you share more logic of the matrix chart?

Community Support Team _ Jimmy Tao

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