cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Community Champion
Community Champion

Re: IF - True statement text

Is there a line separator other than , or ;

Highlighted
Helper III
Helper III

Re: IF - True statement text

Don't know why, but when I use this formula, it works a bit wired:

 

B = if(Movimientos[A]<500,1,0)

 

Captura.PNG

Highlighted
Super User VII
Super User VII

Re: IF - True statement text

It means it has to do with string qualifier.






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

So how do I go on?

Highlighted
Helper III
Helper III

Re: IF - True statement text

Seems this works, but can't undestand why:

 

B = if(Movimientos[A]<500,1,"Lower","Higher")

Highlighted
Super User VII
Super User VII

Re: IF - True statement text

This is weird, can you put a sample data in a pbix file and send it by email, would like to look at my end. I know it seems weird but not sure what else to say? 






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
Super User VII
Super User VII

Re: IF - True statement text

wow that is strange.






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
Community Support
Community Support

Re: IF - True statement text

Hi @chrisgehm

 

Did you use the direct query mode to connect the datasource? If Dax formula still has the issue, I'd like to suggest you use power query formula.

 

#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each if [Column] >5 then "Greate than 5" else "Less than 5")

 

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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