I needed to quickly create a calculation that tested for the presence of a string in another column's text values. There are two ways to solve this, but the first one is an interesting example that you can use in several situations. This solution plays on the true-false values of the DAX IF function in PowerBI.
How do I make it easy for the end user to move the source Excel File around while making it easy to update the source location in PowerBI? Query Parameters solved that issue making the solution a lot easier to maintain.
Update: This issue has been corrected with the August 2017 update release. One of the must-have features I have been desperate to see in PowerBI is the ability to have word wrap in tables. The June 2017 Update, released on July 3, has updated Table and Matrix visualizations which include a number of new features.... Continue Reading →