Hi everyone
I have a strange issue with a calculated column that I've setup. The formula for this column is below:
RiskColour = IF('Table1'[Risk] = "1 - Low",1, IF('Table1'[Risk] = "2 - Medium",2, IF('Table1'[Risk] = "3 - High",3,0)))
This column should return a number between 1 and 3 based on the risk text value. If the risk doesn't match any of these values (which shouldn't happen as this is a mandatroy field in a SharePoint Online list) then the column should return 0.
However when I add this column to my table visualisation in PBI Desktop I get the following:
Can anyone see any reason why the first record would return 4 for this calculated column? Every other record is correct but for some reason the top record has returned 4 even though the formula in my calculated column should never return 4?
Any assistance with this would be gratefully received as I can't see why this is happpening.
Thanks in advance.
