cancel
Showing results for
Did you mean:
Highlighted
Member

## Filter argument add to existing DAX formula

Hi guys,

I have created the following formula to capture the unique new funded clients

('meAccountTransaction',ALLEXCEPT
('meAccountTransaction','meAccountTransaction'[ClientID]),'meAccountTransaction'[TransactionDate] < EARLIER

The above gives me the value whether "New or Additional",  based on date (EARLIER) regardless of the amount of the deposit & nor if there is any earlier deposit in the current month.

What I would like to have is:

_______

1- IF meAccountTransaction'[ClientID] does not exist prior to this month

&

2- IF meAccountTransaction'[Sum Deposits] per  meAccountTransaction'[ClientID] during the current month is greater than 200

Then

_______

appreciate any help

Thanks,

M

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

## Re: Filter argument add to existing DAX formula

@majdkaid22

In this scenario, you can just use MONTH() to compare the month part of [TransactionDate], and use AND() to combine the condition in IF(). The expression can be like:

```New/Additional = if(
AND(
ISEMPTY(
CALCULATETABLE
('meAccountTransaction',
ALLEXCEPT('meAccountTransaction','meAccountTransaction'[Cli​entID]),
MONTH('meAccountTransaction'[TransactionDate]) < MONTH(EARLIER
('meAccountTransaction'[TransactionDate]))
)),
'meAccountTransaction'[Sum Deposits]>200), "New", "additional")```

See my test sample below:

Regards,

2 REPLIES 2
Moderator

## Re: Filter argument add to existing DAX formula

@majdkaid22

In this scenario, you can just use MONTH() to compare the month part of [TransactionDate], and use AND() to combine the condition in IF(). The expression can be like:

```New/Additional = if(
AND(
ISEMPTY(
CALCULATETABLE
('meAccountTransaction',
ALLEXCEPT('meAccountTransaction','meAccountTransaction'[Cli​entID]),
MONTH('meAccountTransaction'[TransactionDate]) < MONTH(EARLIER
('meAccountTransaction'[TransactionDate]))
)),
'meAccountTransaction'[Sum Deposits]>200), "New", "additional")```

See my test sample below:

Regards,

Member

## Re: Filter argument add to existing DAX formula

@v-sihou-msft apologies for my late reply. it has indeed worked out!

Thanks mate

Announcements