Hi,
So after spending a full day playing around with Power BI after never using it before I'm getting the hang of it and have made my first project (attached).
I've noticed I'm going to need to change the data type on a number of my columns from Numbers which have the values 0,1,2,3,4 to True/False so that 0 will be False and 1,2,3,4 will be True.
But then this will mean ill need to update some of my Columns I've made that use the following DAX:
and that would result in a number.
But now that I'm having to change the data type on that column I'll need to update the query (the existing one still works but still outputs a number value). How would i do it so:
So as long as there's 1 True value then the output will always be True.
I'm having one of those days where my head is not thinking right as this is probably an easy thing to do
EDIT: My brain finally kicked in, I've done the following, can you confirm if this is a good way of me doing it or is there a better way?
Any help would be great.
Thanks
Bookmarks