Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX problem

Dear members,

 Please kindly help to solve the following problem:

 1st: I have inserted a table.

 2nd: I want to count the total of number days in the new added column between column lunes and column viernes (see the picture)

Is there any way to solve that?

 

Best regards

Chi

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous what is the logic for new column? How you get to number 5? What happens to other rows in your sample data?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Dear,

       That is i want to get, it means that I want to use Countif as Excel in Power BI to get 5.

       IS there any way to get that?

       

      Best 

      Chi

      • parry2k's avatar
        parry2k
        Super User
        7 years ago

        Anonymous can you tell me how you will write countif in excel and then I can translate it in DAX