Forum Discussion

YDi's avatar
YDi
New Member
2 years ago

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

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

 

 

Need Help

4 Replies

  • ExcelMonke's avatar
    ExcelMonke
    Icon for Impactful Individual rankImpactful Individual
    2 years ago

    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's avatar
      Dixy
      Frequent Visitor
      2 years ago

      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's avatar
        ExcelMonke
        Icon for Impactful Individual rankImpactful Individual
        2 years ago

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