Forum Discussion

Bebs's avatar
Bebs
Helper II
2 years ago

min / max on boolean

Hello !

Is there a way to use min or max functions equivalent on boolean fields ?

I've a boolean field, I'd like to write a DAX calculation (as efficient as possible) to know if it does exists TRUE values or FALSE values in a boolean field.

Can you please help me ?

 

Thanks !

Need Help
Tips and Tricks

3 Replies

  • Bebs's avatar
    Bebs
    Helper II
    2 years ago

    My point can be reformulate to use an AND or an OR functions on every values of a field (and not only two values) As if AND and OR Functions were aggregate functions.

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Bebs 

    Thanks Tahreem24 . I have the following additions, and based on your description, I have created the following sample data:

    In aggregate functions, only the following functions can aggregate Boolean columns:

    You can eradicate what these aggregaters return and adjust them to suit your scenario. I've uploaded the PBIX file I used this time below.

     

     

     

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.