Forum Discussion
Normalizing Periods from Dates
so you basically want to rank the dates for each category
try this calculated columnColumn = VAR Cat = Table[Category] RETURN RANKX(FILTER(Table,Table[Category]=Cat),FIRSTDATE(Table[Date]),,ASC)
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.
| Category | Date | Quantity |
| Category 1 | 01.01.2015 | 5 |
| Category 1 | 01.02.2015 | 7 |
| Category 1 | 01.03.2015 | 12 |
| Category 1 | 01.04.2015 | 8 |
| Category 2 | 01.02.2015 | 3 |
| Category 2 | 01.03.2015 | 5 |
| Category 2 | 01.04.2015 | 8 |
| Category 2 | 01.05.2015 | 12 |
| Category 2 | 01.06.2015 | 14 |
| Category 2 | 01.07.2015 | 7 |
| Category 3 | 01.03.2015 | 4 |
| Category 3 | 01.04.2015 | 2 |
| Category 3 | 01.05.2015 | 2 |
| Category 3 | 01.06.2015 | 8 |
| Category 4 | 01.05.2015 | 3 |
| Category 4 | 01.06.2015 | 2 |
| Category 4 | 01.07.2015 | 7 |
| Category 4 | 01.08.2015 | 9 |
| Category 4 | 01.09.2015 | 3 |
| Category 4 | 01.10.2015 | 3 |
| Category 4 | 01.11.2015 | 8 |
| Category 5 | 01.06.2015 | 7 |
| Category 5 | 01.07.2015 | 6 |
| Category 5 | 01.08.2015 | 7 |
| Category 5 | 01.09.2015 | 7 |
Any known means to achieve something like this?
Best regards,
Stian
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
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