Forum Discussion

sfn's avatar
sfn
Frequent Visitor
8 years ago
Solved

Normalizing Periods from Dates

Hi,

 

Does anyone have experience with normalizing date ranges to represent periods starting at n for a set of categories?

 

I have a lot of data on hours spent to execute specific projects, and I would like to compare their evolution over time starting at the same period n - rather than their respective start dates in order to generate a comparable profile.

 

Cheers,

Stian

Need Help
  • Stachu's avatar
    Stachu
    8 years ago

    so you basically want to rank the dates for each category
    try this calculated column

    Column = 
VAR Cat = Table[Category]
RETURN
RANKX(FILTER(Table,Table[Category]=Cat),FIRSTDATE(Table[Date]),,ASC)

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    sfn,

    You can create date slicer and select specific date value in the slicer to filter your visuals. Or you can create measures if necessary.

    Please share sample data of your table and post expected result here so that we can provide you proper methods.

    Regards,
    Lydia

    • sfn's avatar
      sfn
      Frequent Visitor
      8 years ago

      Anonymous,


      Thank you for your response, Lydia!

       

      Example data below and graphs showing original representation per month and how I would like to represent it aligned at Start or aligned at Start and End points. 

       

      CategoryDateQuantity
      Category 101.01.20155
      Category 101.02.20157
      Category 101.03.201512
      Category 101.04.20158
      Category 201.02.20153
      Category 201.03.20155
      Category 201.04.20158
      Category 201.05.201512
      Category 201.06.201514
      Category 201.07.20157
      Category 301.03.20154
      Category 301.04.20152
      Category 301.05.20152
      Category 301.06.20158
      Category 401.05.20153
      Category 401.06.20152
      Category 401.07.20157
      Category 401.08.20159
      Category 401.09.20153
      Category 401.10.20153
      Category 401.11.20158
      Category 501.06.20157
      Category 501.07.20156
      Category 501.08.20157
      Category 501.09.20157

       

       

       

      Any known means to achieve something like this?  

       

      Best regards,

      Stian

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        sfn,

        Create a measure using DAX below and create a Line chart as shown in the following screenshot.

        Measure = SUM(Table1[Quantity])+0



        Regards,
        Lydia