Power Query using True / False in calculated field - result shows Table

[Jan]

Hello,

I very new to using Power Query (a couple of weeks) and could use some help.
I have attached an image of my query and the formula. Why does my Opportunity column show "Table" instead of the result? I have changed the verbiage of True/False to upper case/ lower case, etc, but am not getting the desired output to calculate columns if M1 & M2 both equal false, or calculate different columns if both equal true, etc.

TIA,
Jan

 

[AliGW]

Attcahing the workbook would be mure use than a picture of it.

 

[Rudi]

I agree with AliG, but as a 2 cents guess, unless its part of the design, and anomaly I see is that you have a nested Table.AddColumn duplicate inside the formula. What happens if you remove this nested duplicate (and the extra bracket at the end).

Click on this image below and zoom in to see what I redacted...

 

[Jan]

Hi Ali,

I'm not sure how I would do that since the workbook looks a files on the network. There is also private company information.
If I can provide something else that would be more helpful, please let me know.

Kind regards,
Jan

 

[Jan]

Hi Rudi,

Thank you so much that worked along with changing TRUE/FALSE to lower case without the hyphens. I have no idea how that duplicate data was inserted.

I very much appreciate your help.

Kind regards,
Jan:cheer2:

 

[Rudi]

Glad to hear you came right. An good catch on changing the TRUE/FALSE. Power Query is case sensitive and these boolean output values (as you have discovered) is lowercase.