Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX Filter Assistance

So I am looking to create a column using a DAX Expression that identifies whether an assignment was past due or not. The column is called "Due in Canvas". And I am looking to use a column that will display whether or not it is later than today's date. 

 

So on the raw file, it is using a COUNTIF function to determine how many assignments were submitted later on a due date:

              =COUNTIF(Assignments!):),"<"&TODAY())

 

I know you cannot do a COUNTIF in PowerBI. I was curious to see if there is any other options I may have to achieve this count?

  • Anonymous's avatar
    Anonymous
    4 years ago

    I think I got it! But I could be wrong. So what I did was create a another column called past due. And did an IF statement to determine if the date is < TODAY && if the Deliverable was " Not Received"

5 Replies

  • SpartaBI's avatar
    SpartaBI
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Anonymous ye sure, quite easy, just not sure exactly what you need. Can you share a sample file or a copy paste table from excel with the desired result?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      SpartaBI 

      The ask is to create 2 visuals very similar to this. The report have has the total. I got the Total Assignments fine (easiest one to do). And then I was able to use a SWITCH (TRUE() to determione the multiple statuses of an assignment as Received or Not Received.