User cannot display IF function Then Else

[Syndicate_Admin]

Hello

I have tried everything, update the power bi, change the locale, the language, the time and even so in the functions of the Dax in custom column these functions still do not appear, I appreciate a guide.

[Adamboer]

If you have tried changing the locale, language, and time settings in Power BI Desktop and are still not able to access certain DAX functions in the custom column, there are a few other things you can try:

1. Check the version of Power BI Desktop you are using. Make sure you are using the latest version available.

2. Check if the function you are trying to use is available in the version of Power BI Desktop you are using. Some functions are only available in certain versions.

3. Check if you have the necessary permissions to use the function. Certain functions may require administrative permissions.

4. Try reinstalling Power BI Desktop. Uninstall the current version and then download and install the latest version available.

If none of the above solutions work, it is possible that the function you are trying to use is not supported in Power BI Desktop. In that case, you can try using a different function or consider using a different tool that supports the function you need.

[amitchandak · Accepted solution]

@Syndicate_Admin , In a dax column if should work like

new column = if([col A] =3, "A", "B")

If then else works in power query

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.