Wanting to display a chart of active guests during a certain time period

[JackSkeletor]

Hello all,

Apologies if this question has been answered in another thread, please pass me onto said thread if there is one!

So we have guests staying in our buildings and we want to be able to display how many guests we had during a certain date range on a visual graph, so that we can determine any trends that may be happening. 

I have a table with a list of names and their start and end date with us, how can i compile this data to be able to view it in a chart that can show me the trends of check-ins over 2022 for example? 

[Ashish_Mathur]

Hi,

I have answered a similar question here - Re: How can i display active members during a time... - Microsoft Power BI Community.