qtde next delivery

[RogerioTortosa]

I need help
I have a basis with the sales data and delivery date of those sales
The user will have to inform a query date and I need to return the following result

Product name /  qtd next delivery in monday / qtde next delivery in Tuesday / ... / qtde delivery next in Friday / qtde later delivery

Example =  if user report data = 22/06
Need to know the qtde to be delivered on days 26, 27, 28, 29, 30 and later

Att.

[v-chuncz-msft]

@RogerioTortosa,

You may start from DAX CALENDAR Function and a Matrix visual.

[tringuyenminh92]

Hi @RogerioTortosa,

Basically, I understand your situation but could you please provide sample data to ensure that i understand correctly? So I could propose correctly solution.

[RogerioTortosa]

Hi,

data

https://1drv.ms/u/s!Au1L5zHi1GMN4k-k6jC4t-gmJS-p

[RogerioTortosa]

Hi,

Follows the attached data

Delivery orders

[v-chuncz-msft]

@RogerioTortosa,

Have you tried the Matrix visual?

[RogerioTortosa]

Hi,

We have other columns that will be placed that are not in temporal period