Calculate total days from a selected date

[Anonymous]

I have a project currently I am working on right now, and I am struggling to get this methodology to work.

For instance, end user selects a date, based on the date selection, it calculates

1. Date diff between the selected date and “Referral date”

2. Calculates the weeks based on the step1.

3. Group step 1 ( so it’s the week falls <10 then group 0-10 week, >=10 && <20 then 10-20 etc) I am particularly struggling around the groups which I am trying to do it in a column as Id need to create another column to sort the Week order and need to show this is a clustered chart.

What I really want to do is this. 

Any help would be appreciated. 

[AlexisOlson]

One name for this is "static segmentation". I'd recommend checking out this article and/or associated video:

https://www.daxpatterns.com/static-segmentation/