cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Upcoming Events

Upcoming Events

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

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Community Blog

Community Blog

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

Top Solution Authors