Show member list based on current month

[ndsmis]

Dear All,

I have a member list (member dimension table) with "Date of Joining" and "Date of Membership Cancellation". 

Member ID       Date of Joining      Date of Membership Cancellation

================================================

A001                  12/Jan/2018           14/Sep/2019

P003                  14/Dec/2018           31/Oct/2019

A005                  13/Dec/2014           

A003                   21/Jan/2015

=================================================

  (Here, "blank" in membership cancellation means Member still active and not cancelled)

Any calculation requires "Current Month Member List" which can be calculated based on Member dimension table and the month selected in Month slicer.

How do I show Members based on month selected from Month's slicer OR restrict the members only for the current month selected?

Any help will highly be appreciated...

Thanks in advance.

Parth

[Mariusz]

Hi @ndsmis 

Please see the attached file with a solution, this type of calculation is easier to perform in the query editor by expanding dates between start and end, hope you don't mind.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.