Reza Rad over at http://radacad.com/dateadd-vs-parallelperiod-vs-sameperiodlastyear-dax-time-intelligence-question explains the differences and provides easy usage scenarios for DateAdd, ParallelPeriod and SamePeriodLastYear DAX functions. Read his blog post to see how he reached to below conclusion: DateAdd and SamePeriodLastYear both work based on the DYNAMIC period in the filter context. ParallelPeriod is working STATICALLY based on the interval selected in the … Continue reading What and when: DateAdd vs ParallelPeriod vs SamePeriodLastYear
Power BI: The key didn’t match any rows in the table
Error: Refreshing Power BI report generates "The key didn't match any rows in the table" error. Cause: Click "Edit Queries" button. If you do not see the error message, click "Refresh Preview" button. Once you have the error message, click "Go To Error". Error message will remain, but you should have "Edit Settings" button now, … Continue reading Power BI: The key didn’t match any rows in the table
How to get and view WordPress Statistics in Power BI
Soheil Bakhshi from http://biinsight.com has a super good article on how to get your stats from a WordPress site/blog and analyze them in Power BI. For lazy guys out there, he already built a Power BI template file that you can use straight away. The only thing you'll need is WordPress API key but don't … Continue reading How to get and view WordPress Statistics in Power BI
What sites I logged in to using my Facebook credentials
Visit www.facebook.com/settings?tab=applications to see what applications and websites you're logging in to using your Facebook credentials. You have 3 tabs to look at: Active: You recently logged into them with Facebook. These are active apps and websites that can access your Facebook data you chose to share with them. Use this list to: 1) View and update the … Continue reading What sites I logged in to using my Facebook credentials
Expressions that yield variant data-type cannot be used to define calculated columns.
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
Creating an e-book. Part 3.
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.
How to automatically create and update Visio diagrams from Excel
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
How to start Word with a specific template
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
How to use Word for Blog publishing
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
Creating an e-book. Part 2.
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.