Dynamic count of customers

[Anonymous]

Hi

I want a count of customers as a measure

- I have a dates table that is calculating my FY and months

- the count of customers is on a table that also has created on date

My measure should say count of these customers if i select FY date month as July then take created on date from the beginning (lets say 2015 until Jul today) plus if i select Aug from FY month then this count should change in Aug automatically taking created on date as Aug

Sample format below(Created on date starts from 2015 till today, it has new customers and the count i need from here)

-FY has my dates from 2019 , this goes from Jul-Jun as my months(these are in my columns):

[Anonymous]

Hi @Anonymous,
Can please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,
Xiaoxin Sheng