How can i display active members during a time period on a bar chart?

[NoobBI]

So I have this table:

Name | startdate |end date

J.Jones| 01/01/2020 | 01/01/2021

A.Adams | 01/01/2022 | blank

Mr. T | 01/06/2021 | 01/04/2023

I basically want to be able to produce a bar chart that displays the amount of active users we had month by month, for us to be able to identify trends easily. But i'm finding it very difficult and can't seem ti find what I need online. So any help is greatly appreciated!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Greg_Deckler]

@NoobBI See this approach here: Open Tickets - Microsoft Power BI Community