Filter numbers between parameters rather than actual dates

Question

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.&nbsp;&nbsp; &nbsp;

lbendlin · Answer

Does your data model include Dates/Calendar tables?

javadjafari · Answer

Thanks Ibendlin. Yes it has.&nbsp;

lbendlin · Answer

Would you mind showing the data model?

javadjafari · Answer

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

lbendlin · Answer

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.&nbsp; Correct that and then link from Dates to Data as a 1:M relationship with single filter direction.

Forum Discussion

Filter numbers between parameters rather than actual dates

7 Replies

Related content

Using parameters to filter to desired number of rows

Parameter in summarize

notebook parameter

Parameters to fabric pipeline

Field Parameter Question