Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

grouping dates dynamically

Hi All, 

I want to be able to group dates into a list where each value contains a range of 14 days (fortnight period), however, i need it to be done dynamically. Any idea how to do that? 

I know that you can manually go and create groups, but i want it to dynamically create groups of 14 days. 

Thanks all 

4 Replies

  • Stachu's avatar
    Stachu
    Community Champion
    7 years ago

    I don't understand what does dynamically mean in this context - when would it change?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Ideally, when i select a date on a slicer, i want it to show me 3 months before that date but i was wondering if it's possible to, when selected, the view of the previous 3 months is shown in a bar or line chart and the dates that occur in those three months has grouped into fortnight groups.  

      • Stachu's avatar
        Stachu
        Community Champion
        7 years ago

        hmm, bins are essentially an additional UI to create a calculated column. Calculated columns do not change based on a slicer changes, only when the table is refreshed.

        Now you can write DAX that would group the column differently at every refresh (e.g. last 14 days with current date always at the start), see below

        Column = "Fortnight " & INT(DIVIDE('Calendar'[Date] - TODAY(),14))

        but you only a measure can change based on a slicer selection


        so ideally you would like to select e.g. Feb 2019, and a barchart would display data for Nov 2018-Jan 2019?
        what would you do with the fortnight bins in this scenario?