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...
Need Help
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