Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Ture / False column with multiple conditions

Hey everyone, 

 

Essentially, I'm trying to build all the following page filters into a single true/false column but I'm just failing each time with the mutiple conditions.  If the conditions are met then True if not false. 

Note. Client Sheet and some are are on the Activites sheet (related by client ID). and PO date rage filter is the last 7 days 

 

Thanks in advance.

 

  • AntrikshSharma's avatar
    AntrikshSharma
    5 years ago

    Anonymous  Let me know if this works:

     

    Column 2 =
VAR DateToday =
    TODAY ()
VAR Activities =
    COUNTROWS (
        FILTER (
            RELATEDTABLE ( Activites ),
            Activites[Column A] = FALSE ()
                && Activites[Column B] = TRUE ()
        )
    )
VAR Conditions =
    NOT ISBLANK ( Clients[PO Date] )
        && ISBLANK ( Clients[Activites NEW.System Code1] )
        && Clients[PO Date] < DateToday
        && Clients[PO Date] > DateToday - 6
        && ISBLANK ( Clients[Episode Start] )
        && NOT CONTAINSSTRING ( Clients[Programme Status], "Ended" )
        && Activities > 0
RETURN
    Conditions

4 Replies

  • AntrikshSharma's avatar
    AntrikshSharma
    Icon for Community Champion rankCommunity Champion
    5 years ago
    Can you please explain this with some example? Also explain how and where you intend to use that column. Is it just a calculated column in a table?

    "I'm trying to build all the following page filters into a single true/false column but I'm just failing each time with the mutiple conditions."
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hey Antriksh Sharma, 

       

      Thanks for your reply. 

       

      If it's any help I'll update a sample PBIX file for you (onedrive link below). Essentailly, I need to create a calculated column on the "Clients" dataset which will result in "True" if all the conditions are met and "False if they are not". You'll see on the Power BI report below, that I've been able to create the conditions using Page/report level filters however, I really need this in a calculaed column. 

       

      https://1drv.ms/u/s!AnIEh6WhI4JogvlY-yO3F1OBOLV-wQ?e=VF2V6g 

      The conditions are 
      * Clients "PO Date" is NOT blank 
      * Clients "System Code1" IS blank
      * Clients "PO Date" Is betwene today and the last 7 days
      *Clients "Episode Start" IS blank
      Clients "Programme Status" Does Not contain "Ended"
      Activities "Column A" is False
      Activites "Column B" is True.  


      Thank you agian. 

      • AntrikshSharma's avatar
        AntrikshSharma
        Icon for Community Champion rankCommunity Champion
        5 years ago

        Anonymous  Let me know if this works:

         

        Column 2 =
VAR DateToday =
    TODAY ()
VAR Activities =
    COUNTROWS (
        FILTER (
            RELATEDTABLE ( Activites ),
            Activites[Column A] = FALSE ()
                && Activites[Column B] = TRUE ()
        )
    )
VAR Conditions =
    NOT ISBLANK ( Clients[PO Date] )
        && ISBLANK ( Clients[Activites NEW.System Code1] )
        && Clients[PO Date] < DateToday
        && Clients[PO Date] > DateToday - 6
        && ISBLANK ( Clients[Episode Start] )
        && NOT CONTAINSSTRING ( Clients[Programme Status], "Ended" )
        && Activities > 0
RETURN
    Conditions