Forum Discussion
Distinct Row Count
Hi, Newbie here. I have encountered difficulties in figuring out how to calculate distinct rows from two columns. I have two tables(see figure): 'Ward_Bed' and its respective admission and di...
saver7890 , Based on what I got, check if the approach having a date table and active inactive relation and using userelationship can help
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Thank you for your attention.
Yes, there is a date table and active relation.
I tried your DAX syntax but the value is still off.
For example, the VIP ward should have 4 distinct counts as the "DOA" and "DOD" have different dates.
Thank you.