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 have to make a relation between my two table but nothing has change I can't reach my goal

 

Any idea?

 

 

Thanks in advnace

 

Need Help

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    A bit tough to decipher, but the equivalent in Power BI for COUNTIF is CALCULATE with a FILTER clause and you could use something like LOOKUPVALUE or SEARCH or RELATEDTABLE or RELATED or something along those lines. Can't really get a sense of you raw data. 

    • 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??