topic Re: Create a measure - Date filtering in DAX Commands and Tips

Create a measure - Date filtering

Anonymous — Thu, 16 Jan 2020 10:51:12 GMT

Hi i am trying to cretae a measure to calculate for example, revenue which is filtered by 2 date ranges, for example

NEW Revenue = (Table1[Revenue]), Filtered by Date[Year]<2019 where the revenue is equal to or less than £0 AND Filter by Date[Year]>2020 where the revenue >£0

is there a simple way to write this in Dax?

Re: Create a measure - Date filtering

PiyushH1 — Thu, 16 Jan 2020 11:59:39 GMT

hello,

I am on your query , but can you please explain me more in detail what you are trying to achive ?

I will try to help you.

Thank you.

Piyush

Re: Create a measure - Date filtering

Anonymous — Thu, 16 Jan 2020 12:02:21 GMT

thnak you, i am trying to work out who are net new customers, i.e those that have not bought certain products before in a set time frame and those who have bought customers this year for example so that we can count the number of them for analysis purposes.

Re: Create a measure - Date filtering

Anonymous — Thu, 16 Jan 2020 14:06:22 GMT

Hi Anonymous

In your logic you have mentioned year<2019 AND Year>2020.

Please check the above logic this will never evaluate to true for AND condition. May be requirement is OR COndtion.

Measure=calculate( Sum(table[revenue]),filter(table, (table[year]<2019 && table[revenue]<0) || (table[year]>2020 && table[revenue]>0) )

Thanks

Pravin Wattamwar.

if it resolves your problem mark it as solution and give kudos.

Re: Create a measure - Date filtering

PiyushH1 — Thu, 16 Jan 2020 15:24:10 GMT

Hi @ballist1x ,

there is a option quick new measue under filter "sales from new customer". please try this.

it should work.

if it resolves your problem mark it as solution and give kudos.

Regards,

Piyush

Re: Create a measure - Date filtering

Anonymous — Fri, 17 Jan 2020 09:54:37 GMT

hi thanks, i tried this but got an error:

"A function 'FILTER' has been used in a True/False expression that is used as a table filter expression. This is not allowed."