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

      • domiowa's avatar
        domiowa
        Frequent Visitor
        8 years ago

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