Using Groupings for Column Values

[Anonymous]

Evening All

Is this possible. I have a slicer which has values that go from -470 to 3

-470 comes from a datediff caluclation which shows when that task is due i.e 470 days in the past i.e its late

3 is that the Task is due in 3x Days.

I have values of say 3,6,9,15,18 and so on.

I wanted to created a Grouping that would be 

• Group 1  (Tasks Due in next 1- 10x days)  - Include <=10   so the date that was due in 3,6, or 9 days would be in this category.
• Group 2   (Tasks Due in next 11-20x days)   - Include >=11<=20   so the date that was due in 15,18, would be in this category.
• etc

Im sure this is possible. I was playing with Groupings and I could not see a way for me to create these Groups and I was looking for some pointers.

I guess a multiple If statemnet would maybe an option in a calculated column

Due Date Grouping = if(tbl_POAP_master[Days Till Due Date]<=10," 10 Day Look Ahead","Something Else")  which gives:

I would need other If statements I guess for 11-20x Days ; 21-40x Days and maybe 41x Days and Over 

Thanks

Jimmy

[christinepayton · Accepted solution]

Is this a question? Your solution is a typical way this is solved for; you could do it in Power Query as well with a calculated column. Not sure what you mean by grouping - you could drop the text field you created into a matrix to get it to group your records by that column, or group by it in Power Query, or so on. Or use that text field in the slicer. 

[Anonymous]

Hi @christinepayton 

I guess these are the ramblings of a mad man.  I started writing it and lost my way and was... just rambling.

Im going to re-type my qustion as I was overthinking it.

[christinepayton]

We all have those rambling days haha 🙂