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 ...
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)
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

      • sfn's avatar
        sfn
        Frequent Visitor
        8 years ago

        Hi Lydia,

         

        I've attempted this and it doesn't yield the result I'd like as it seems to fill the line-points without values as 0 values.

         

        I'd like to use a measure that could;

        take a specific category's first month and label it as 1, 

        take a specific category's second month and label it as 2 etc.

         

        Then display these labels as the x-axis.

         

        Best regards,

        Stian