Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello all,
i am stuck with what i think is quite a simple task, but just cannot get my head around it.
I have data columns ( 11 columns to be precise) which are extracting data from power apps with results being - true false or blank, as shown on screenshot.
What i want to do is create an additional column which will display results based on the following conditions. Check all the columns and:
- if there is only true results (and blanks) in the columns - "passed"
-if there are only false results (and blanks) - failed
- if true and false are displayed - partially passed
What i was thinking is to using switch function and checking column by column but this seems like a lot of DAX. so not sure if additional columns and some DAX is the best solution or if there are other possibilities but help is appreciated.
thanks!
Solved! Go to Solution.
Hi,
In the Query Editor, select all columns other than the 11 TRUE/FALSE columns and select "Unpivot other columns". This should get you started. To get more help, share the link from where i can download your PBI file.
Hi,
In the Query Editor, select all columns other than the 11 TRUE/FALSE columns and select "Unpivot other columns". This should get you started. To get more help, share the link from where i can download your PBI file.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |