How to build report/measure showing month to month data

[badgerr11]

I'm trying to build into a report a tile that will show a break down month by month how many clients have signed up for one of our services. This would go back from the start of the service (a couple of years ago) up to the current month. I'm not sure what to use. Is this something for DAX or M? Thanks!

[v-lili6-msft]

Hi@ badgerr11 

please try this demo,if the result match your expected output.

https://www.dropbox.com/s/7li701q8hbu995q/DEMO.pbix?dl=0

Best Regards,

Lin

[Anonymous]

Hi @badgerr11

You can do this in Power BI visuals and using some DAX, quitestraightforward one.

Create a measure cntofcustomer= COUNT(Table1[Customer_ID])

Assume you have Enroll_date, Create a Year-Month column with DAX :  CONCATENATE(YEAR(Table1[Enroll_Date]), MONTH(Table1[Enroll_Date]) )

Now pull the required dimension along with the above created measure/ object.

Foe Ex: Pull Service_Categoy, Year_Month, CountofCustomer.

This will giev the required result.

Thanks
Raj