Distinct New clients - Last FY, FYTD, Last month, this month

[Anonymous]

Hi Community,

I need help in calculating distinct new clients Last FY, FYTD, Last month, this month. 

FY starts on July 1.

So, last FY = 1 Jul 20 - 30 Jun 2021

FYTD = 1 Jul 21 - today

Follwoing is my sample data set & expected result (in matrix form). Measure for 'This month' is in the Pbi file.

@Ashish_Mathur  updated Pbi: https://1drv.ms/u/s!Ag919_pO_UKrgRsvDQaPDqbiFQhz?e=KFhYco

Thanks!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous]

@Ashish_Mathur Thanks heaps! I want the solution to work without the financial year & month selection. It doesn't work if I remove financial year & month filters on the page. Please suggest.

Also, would you suggest why the totals are not correct?

[Ashish_Mathur]

You are welcome.  I have devoted anough time to framing this solution and would not like to invest more time on this new request.  May be someone else can help you wih this.

[aj1973]

Hi @Anonymous 

First you need to add FY column to Datedim

And a column for month number

then use FY to determine the distinctcount of Client ID

I hereafter attached your file

https://drive.google.com/file/d/1fJmaRojA2GegsjTb2gcu1gU39z-WAQ-b/view?usp=sharing

[Anonymous]

@aj1973 thanks for replying, but this solution provides distinct clients, not distinct new clients.