Posted inDynamics NAV & BC Tips & tricks
Adding full text search to the Search App
The work continues on the Search App. In this episode I tackle the full text search. Source : Hougaard.com Read more...
Posted inData & Analysis
Removing HTML Tags From Text In Power Query/Power BI
Recently I found I needed to remove all the HTML tags from some text in Power Query. I searched and found a great – if complex – function from Marcel Beug here, but I realised that since that post was written the Html.Table M function has…
Posted inData & Analysis
Conditional Formatting with a Text Field in Power BI
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…
Posted inData & Analysis
Splitting Text By Character Transition In Power BI And Excel Power Query
The February 2019 release of Power BI Desktop includes some new functionality not mentioned in the summary blog post, functionality that is already in the latest Excel 365 builds (thanks Ed Hansberry for pointing this out) and will be extremely useful. It takes the form of…
Posted inDynamics NAV & BC Tips & tricks
Using Memo BLOB to Enable Huge Text
Generally speaking, enabling huge text fields in NAV is bad design because it encourages dumping unstructured data into the system. Reason Codes is an example of adding useful, structured data to the system. But, every once in a while, there’s a legitimate need to write up…
Posted inData & Analysis
Text Filtering in Power BI
There are lots of different ways you can filter data in Power BI including: • Slicers (with various configurations) • Cross filtering from any visual object • The filters pane on the right hand side of your report • Custom visuals designed specifically for filtering Bron…
Posted inDynamics NAV & BC Tips & tricks
NAV2018 Getting rid of the Text 1024 limitation
With NAV2015 we got Text variable with length only limited by DotNet (1 billions characters). But the standard NAV application still had several 1024 characters limitation, one of them was the handling of filtering on dimension values. Bron : Hougaard.com – Applied Hacking Lees meer...