Although the conditional formatting by rules feature in Power BI was released a long time ago, one very common cause of confusion is with how to implement basic “greater than” or “less than” rules. For example, say you have a table with the following data in it:
One of the things I like about my live, online training courses is that I get to hear great questions from the trenches from people learning DAX and Power BI. Last week, John asked me how to apply conditional formatting with a Text field (not a numeric field). I knew it could be done, but it required some brief research before I could give an answer
The debugging process is for many people one of the most tedious tasks a developer has to do.
Depending on the complexity of the process you are trying to debug, this action can take from a few seconds to a few hours. A few hours of seeing the same lines of code over and over…
Last week we discussed how to apply standard formatting codes for currencies and dates to Microsoft Dynamics NAV 2009 RTC reports. As I mentioned in that blog post, there are some hoops we have to jump through in order to show more than one culture’s formats on the same report. In the typical report the localization information is contained in the report header and it will only include a single localization.
For a recent project, I needed to export the object properties of a number of objects to an XML file.
As you know, in the Object table, there are separate columns for Date and Time. Initially, I exported each column as an individual XML attribute, using the FORMAT function’s standard format #9 to XML-format the values