Filter numbers between parameters rather than actual dates

[javadjafari]

Hi Everyone,
I have faced an issue and was wondering if you can please help me with.

Assume I have couple of patients (according to following table) with 2 visits. Also they take medications in different times where they submit a code for each. Now, I need to filter the number of submissions per each patient in different time ranges (e.g between D1 and D2 or between D1 and Today and so on) instead of importing associated dates to those parameters (D1, D2) manually for each patient using the slicer.
Thanks.

    

[lbendlin]

Yes, this looks good.  Now create your desired visual, and then adjust the measures accordingly.

[lbendlin]

I don't think your Dates tabe is a proper calendar table without gaps. It also does not appear to be marked as a Dates table.  Correct that and then link from Dates to Data as a 1:M relationship with single filter direction.

[javadjafari]

Thanks for your help, Do you think it`s ok now?
And do you think the questions I had technically possible in Power Bi? Thanks.

[lbendlin]

Does your data model include Dates/Calendar tables?

[javadjafari]

• Thanks Ibendlin. Yes it has. 

[lbendlin]

Would you mind showing the data model?

[javadjafari]

This is the model lbendlin. Patients and Data tables are connected through the Patient Numbers. The other two through Date and Submission Date. Thanks.