hi

[abc_777]

Hi,

need a custom date range. 

i need custom type date range like

1-7-2022 - 8-7-2022 or 12-12-2022 - 31-12-2022

any date from and to 6,7,8,9 days of interval 

please help

Date Range	Customer Name	Quantity (KG)
1-7-2022 To 8-7-2022	A	2
9-7-2022 To 16-7-2022	B	5
17-7-2022 To 24-7-2022	C	10

thanks

[v-yiruan-msft]

Hi @abc_777 ,

Do you want to want to get one field with different data ranges? What's the logic of date ranges? And they are dynamic base on the slicer selections or something else? In order to give you a suitable solution, could you please provide some raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[abc_777]

hi @v-yiruan-msft 

in this thread i have shared a matrics what i am looking for or how i want to see date range in matrix. 

[amitchandak]

@abc_777 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[abc_777]

please check my post now. hops it's now clear. if anything is not clear please ask.