Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have Member_ID, Admit_Date, and Discharge_Date from a fact table and a CalendarDate from a Dim_Date table.
I am using CalendarDate as the axis on a line graph and want to show the number of members who were currently admitted on each date...meaning the calendar date was between the Admit_Date and Discharge_Date.
This is what I did for the measure, but I don't think it is right.
@Anonymous ,
You may refer to the post below.
Hi,
Thanks! This gives me the counts I am looking for! Instead of COUNTROWS, is there something else I can use to also identify the associated Member_ID's as well?
Thanks in Advance,
Ronald
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |