Forum Discussion
Active Clients by Month
Hi I am new to Power Bi and need some help in trying to be able to calculate "active clients" by program each month. I am using a connection directly to a CMS system which is providing me with th...
hi, Anonymous
Here is the same post for you refer to:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
For your case, just add a conditional that if there is no value in "program end date" should it be "Today" or other default date.
Best Regards,
Lin
v-lili6-msft
Community Support
Community Supporthi, Anonymous
Here is the same post for you refer to:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
For your case, just add a conditional that if there is no value in "program end date" should it be "Today" or other default date.
Best Regards,
Lin