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

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

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi domiowa,

You said "I'd like to get my Date(2016,10,1) et Date(2016,11,1) directly from a table" Let's assume the table name is Date, what the table look like? There is relationship between 'Date' and 'TabJalons', what's the relationship? Could you please share more details or .pbix file for further analysis?

Thanks,
Angelia