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

Thank for your quick answer

So the idea is is to compare my month with end and start date

First Case: Sumif((StartDate < Month) AND end Date => Month +1))

And all my calculation are similar to this case

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

But what does the data look like? I get there is a start date and an end date, but where is MONTH coming from? Is that current month or is that coming from another table??

  • 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

      • 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