cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Re: IF - True statement text

Spanish

Highlighted
Super User VII
Super User VII

Re: IF - True statement text

Can you check regional settings in PowerBI,

 

-go to menu

-options and settings

-options

-regional settings

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Helper III
Helper III

Re: IF - True statement text

Captura.PNG

Highlighted
Resolver III
Resolver III

Re: IF - True statement text

Under regional settings --> Addtional Setting

 

Check what is the List Seperator defined. Use that one or change it to comma(,)

Highlighted
Community Champion
Community Champion

Re: IF - True statement text

Folks he said he got the same error with , and with ;

Highlighted
Super User VII
Super User VII

Re: IF - True statement text

I changed my regional setting as yours and tested the formula and it worked, not sure what else to tell. @FarhanAhmed1984 mentioend something for you to take a look, can you check?

 

Also, can you change your regional settings for "English (USA)" and test it. It is only for testing purpose.

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Helper III
Helper III

Re: IF - True statement text

Don't have the Addtional Setting option

Highlighted
Resolver III
Resolver III

Re: IF - True statement text

Control Panel --> Region ---> Additional Settings --> List SeperatorRegional Setting.png

Highlighted
Helper III
Helper III

Re: IF - True statement text

I've change both system and pbi settings to usa, but still got the same problem

Highlighted
Super User VII
Super User VII

Re: IF - True statement text

Can you test by changing regional settings to English (USA).

 

Also, can you create a temporary table in PowerBI and test it. Just trying to rule out all the optionsl . All these seems hit and trial but very hard to find the reason since formula is correct.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors