Forum Discussion
dax for tasks
hi
i want to find the count of where tasks=dpdswapit and task template id= engvisit
from tasks table
Anonymous ,
Like
Calculate(count(Table[tasks]) , filter(Table,Table[tasks]="dpdswapit" && Table[task template id]= "engvisit"))
or
Calculate(count(Table[tasks]) , filter(Table,Table[tasks]="dpdswapit" && Table[task template id]= "engvisit"),DATESMTD(dateadd('Date'[Date],-1,MONTH))
2 Replies
- amitchandak
Super User
Anonymous ,
Like
Calculate(count(Table[tasks]) , filter(Table,Table[tasks]="dpdswapit" && Table[task template id]= "engvisit"))
or
Calculate(count(Table[tasks]) , filter(Table,Table[tasks]="dpdswapit" && Table[task template id]= "engvisit"),DATESMTD(dateadd('Date'[Date],-1,MONTH))