Forum Discussion
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...
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.