Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am a bit new to this platfrom, and I am trying to write the below formula, but I am getting a Token RightParen expected error, and I am not sure why is the issue. It is highligting the "FH". Please help me to figure out the issue.
=if(Left([Season],1)="F" then "FH" else "SS")&Rright([Season],2)
Thanks,
WV
Solved! Go to Solution.
Hi @Anonymous
In query editor,you may create a custom column with M language:Text.Start and Text.End like below.
=(if Text.Start([Season],1)="F" then "FH" else "SS")&Text.End([Season],2)
Second way in DAX with IF function.New a column in data view.
Column = IF(LEFT(Table5[Season],1)="F","FH","SS")&RIGHT(Table5[Season],2)
Regards,
Hi @Anonymous
In query editor,you may create a custom column with M language:Text.Start and Text.End like below.
=(if Text.Start([Season],1)="F" then "FH" else "SS")&Text.End([Season],2)
Second way in DAX with IF function.New a column in data view.
Column = IF(LEFT(Table5[Season],1)="F","FH","SS")&RIGHT(Table5[Season],2)
Regards,
This is perfect! Thank you so much for your help!
Wendy
If you are having trouble with the DAX syntax try the following (looks like you wrote this for Tableau. DAX has a learning curve coming from Tableau).
= IF( LEFT([Season],1) = "F", "FH", "SS" )
I am not sure what you are trying to accomplish with the last portion "&Rright([Season],2)"
If my solution didn't work, then it would be helpful if you posted some sample data or at least an example of the sample input and desired outcome.
Where exactly are you doing this. If you are doing a DAX formula, this will not work.
Please look at this similar question and solution...
https://community.powerbi.com/t5/Desktop/if-then-else/td-p/117999
good luck!
Luis
If this was helpful, consider marking it as solved so others can find it easily.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |