How to show Data Grouped by User Defined Date Range? (in table visual)

[YDi]

How to show Data Grouped by User Defined Date Range?

Sample file attached. 

The user is selecting 2 time ranges and I am doing some calculations to show the data, but the problem is that I am unable to group the data in the user-defined time ranges and showing up as 1 row for each date. 

SamplePBIXForTimeFrame 1.pbix

[ExcelMonke]

Hello,
Not an expert like the folks tagged below, but here is something to get you started. 

Have you considered the following:

• Wrapping your NonProd and Prod Counts into a COUNTX/SUMX function?
• Concatenating your Date windows. E.g.:

CreatedDate_NonProd = 
CONCATENATE(MIN('Table'[NonProdDate]),
CONCATENATE("-",MAX('Table'[NonProdDate]))​

[Dixy]

Thanks - I can concatnate - that's not an issue. Problem is more with how to sum the numbers as I am counting the rows with a certain measure value. 

[ExcelMonke]

Consider using a mix of Variables in the SUMMARIZE table function. Each column can be a calculation NonProdCounts and Prod Counts respectively

[Dixy]

@amitchandak @Ritaf1983 @lbendlin @Idrissshatila @PijushRoy 

Can you please help.