Forum Discussion
Is it possible to enter Boolean values in Text data type column? If yes, How?
RamaKrishna8989 This is merely showing you what the results are for each individual event if it were its own column. It's not saying that the outcome of mixed formatted records in a column would automatically calculate the specific output as it is listed in that table. Below is an example of what I mean:
1. The column True/False is boolean structured. Therefore TRUE = 1 and FALSE = 0.
2. The column 1/0 has a blank, a zero and ones. The output is the Measure 1/0s which aligns to the AVERAGEA output.
Hope this makes sense.
Theo 🙂
Here, TRUE and FALSE are considered as Text, i want them to be considered as Boolean so my calculation happens correctly.
RamaKrishna8989 If your source data contains Col 1 and the source data has 1, FALSE, One, TRUE, then you will need to modify the data in Col 1 in the raw source file.
The boolean output should be based on a condition being met or not being met. For example:
I hope this makes sense?
Thanks heaps
Theo
RamaKrishna8989 In addition to the above, your entire Col1 should be TRUE or FALSE if you are wanting it to be treated as such. Once you do that, you can go into Power Query by pressing "Transform Data" and then simply click the "abc" on the column like below:
Once you've done that you can click on "TRUE/FALSE"
This will convert the column to a boolean like below:
Hope this is what you're wanting.
Theo 🙂