Using an IF statement in DAX is very common for most Power BI users. Did you know most of the time you can get the same results in the Power Query editor using a custom column? In this video, I show how and why you would ever want to approach it this way. Using the Power Query editor over DAX will often give you better data compression, indexing, and faster refresh times. In this quick video, learn how to replace your If functions with custom columns and take your Power BI reports to the next level.

If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Matt30" at check out when purchasing our OnDemand Learning classes to get extra 30% off https://pragmaticworks.com/pricing/'>https://pragmaticworks.com/pricing/



Next step on your journey:
OnDemand Learning Start With The FREE Community Plan: https://tinyurl.com/2ujujsb5

Pragmatic Works OnDemand Learning Packages: https://pragmaticworks.com/pricing/'>https://pragmaticworks.com/pricing/
Pragmatic Works Boot Camps: https://pragmaticworks.com/bootcamps/
Pragmatic Works Hackathons: https://pragmaticworks.com/privatetr...
Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtualme...
Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/privatetr...
Pragmatic Works Blog: http://blog.pragmaticworks.com/


Let's connect:
✔Twitter:   / pragmaticworks  
✔Facebook:   / pragmaticworks  
✔Instagram:   / pragmatic.works  
✔LinkedIn:   / pragmaticworks  
✔YouTube:    / pragmaticworks  

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 6385743
Email: [email protected]

~~~~~~~~~
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
   • Free Power Apps Component Library  B...  
~~~~~~~~~