Forum Discussion
New vs Existing Patients
Hi All, I have patients medical claims data for 2 years FY 2017/2018 (FY runs from October 1st to Sept 30th). I have couple of tables like Fact_RX, DimProvider, DimDate,etc..The sample fact data ...
Ashish_Mathur Thanks for taking the effort to help me. However, When I don't have any filters on physician_ID its shows all patients are new Patients overall which is incorrect as Only PatientID 3 is new patient
Ashish_Mathur
Super User
Super UserHi,
My solution return the number of new patients every month. So if no selection is made in the PhysicianID slicer, then you see new patients in each month for all Physician ID's