Error: "Expressions that yield variant data-type cannot be used to define calculated columns." Cause: IF based Calculated Columns in Power BI or Power Pivot with 2 different data types is not allowed. Solution: Format one data type as needed using FORMAT() function. FORMAT Function (DAX): https://msdn.microsoft.com/en-us/query-bi/dax/format-function-dax Pre-Defined Numeric Formats for the FORMAT function: https://msdn.microsoft.com/query-bi/dax/pre-defined-numeric-formats-for-the-format-function
Continuing the series about how to create an e-book. Today we'll have a much shorter post. Specifically, we'll look at how to create the Title page. So, what is a Title Page? According to dictionary.com, Title Page is: "the page at the beginning of a volume that indicates the title, author's or editor's name, and … Continue reading Creating an e-book. Part 3.
To successfully create Visio diagrams from Excel, Visio Pro for Office 365 is required. Here you can see the prices or download trial. Open Excel (I have latest release of Excel from Office 365 suite) In the search box, type "process" and hit Enter. Among other search results, 2 Excel templates should appear with Excel … Continue reading How to automatically create and update Visio diagrams from Excel
Open Word the usual way. In the template selection view, select the template you want and click Create. For example, Blog Post. When Word opened your document, click Save As and select Word Template in the Save as type drop-down box. Path should change automatically to your Custom Office Templates directory. Give your template a … Continue reading How to start Word with a specific template
Start your Office Word application. It works with any version starting with Word 2007. While you're in the new template selection view, search for "blog" in the "Search for online templates" field. "Blog post" template should be listed. Click it and then select Create button. On first run only, you'll be asked to register your … Continue reading How to use Word for Blog publishing
Following on from previous post about creating an e-book, today we will make that "black on white" text look nicer and we will do it using CSS (Cascading Style Sheets). I will not detail on what CSS is because this is not the purpose of this post. If you need to refresh your knowledge, please … Continue reading Creating an e-book. Part 2.
As explained in Ok, E-Books post, this topic became of an interest just recently. I have never created an e-book so you will not see me saying that I’m usually doing it this way or that way or other crap like this. No, cards on the table. I’m just as curious as you are about … Continue reading Creating an e-book. Part 1.
Ever wondered what HTML and XHTML is about? Long and official story can be found at W3Schools. Short story, below.Simply put, XHTML is the same as HTML but stricter. There are rules in place that one must follow. You are no longer allowed to leave tags unclosed or place them wherever you want. And guess … Continue reading HTML vs XHTML
Let's start with some bullshit talk to tell you how this topic started. Feel free to skip it if you’re not curious. Personally, I’m not the kind of person who reads books not related to IT; think I can count all books I read throughout my lifetime and there are no more than 10, but … Continue reading Ok, e-books
After many years, giving this blog a rebirth. I lost my backup files and only found very few posts and those mainly about ConfigMgr 2012. Will post them below anyway; better few than nothing. Next planned articles will be about e-books and plain html maybe, we shall see Stay tuned!Also need to create/update “About” page. … Continue reading Getting back online