Ture / False column with multiple conditions

[Anonymous]

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]

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]

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 · Accepted solution]

@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

[Anonymous]

Worked perfectly thank you.