Forum Discussion

domiowa's avatar
domiowa
Frequent Visitor
8 years ago

Count if

Hi everyone I have a table with my start and ending date, I'd like to make a count if in another table with month So I have no problem to do that on Excel but on power Bi, it's impossible First I ...
Need Help
domiowa's avatar
domiowa
Frequent Visitor
8 years ago

Month come from my table project with project name and ending date and start date

domiowa's avatar
domiowa
Frequent Visitor
8 years ago

So this is what I'd like to do but automatically:

Mesure 2 = Calculate(count(TabJalons[Jalon]);(TabJalons[Starting Date]<DATE(2016;10;1));(TabJalons[Ending Date]>=date(2016;11;01)))

I'd like to get my Date(2016,10,1) et Date(2016,11,1) directly from a table