cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Re: Dax on filtering duplicates and counting with text

Thx for ur reply,

 

The formula gives me the following error:

 

The first argument to 'DATEADD' must specify a column

 

...

Highlighted
Anonymous
Not applicable

Re: Dax on filtering duplicates and counting with text

Hi @Yarisch77 

instead of dateadd(today(),-1,month)

 you can use date(year(today()),month(today)-1,day(today()))

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

Highlighted
Frequent Visitor

Re: Dax on filtering duplicates and counting with text

This actually could also work, giving the same result for the las 60 days or not?

 

Measure 4 = CALCULATE(DISTINCTCOUNT('CPro Server'[Control Number]);filter('CPro Server';SEARCH("A";'CPro Server'[Control Number];;-1)>0 && 'CPro Server'[Action Request Due Date]>= EOMONTH(TODAY();-2) && 'CPro Server'[Action Request Due Date]<=Today() && 'CPro Server'[Status]="Completed"))
 
....
Highlighted
Anonymous
Not applicable

Re: Dax on filtering duplicates and counting with text

 Hi @Yarisch77 

 

this will take whole two months in account. 

It will take last date from previous month to today.

 

I think your requirement is same day from last month to today.

 

I have provided answer for the same.

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.