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 Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors