I couldn't resist of not sharing this. Excelent post from P3 regarding our friendship with Corona virus. https://powerpivotpro.com/2020/03/welcome-to-the-new-normal/
Someone asked me the other day below thing: "On the same column I want a Range of dates not Duration between two dates So I have a Creation date and fulfillment date I need to come up with a column of weekly Range like for example 10/21 - 10/27 10/28 - 11/01 11/02 - 11/09 … Continue reading Power Query – Week start and end dates in same column
Count: SELECT [ProductModel], COUNT(1) CNT FROM [AdventureWorks2017].[Production].[vProductAndDescription] GROUP BY [ProductModel] ORDER BY CNT DESC Count "if": SELECT [ProductModel], [Name],COUNT(1) CNT FROM [AdventureWorks2017].[Production].[vProductAndDescription] WHERE [ProductModel] LIKE '%Frame' AND [Name] LIKE '%52' --here's the IF statement GROUP BY [ProductModel], [Name] ORDER BY CNT DESC Count duplicates: SELECT [ProductModel], COUNT(1) CNT -- select a field you want to … Continue reading Examples of Count, Count IF, Count duplicates in SQL
A new version of ITIL will be released in early 2019.
"Another month, another Power BI Desktop update" as Guy(s) in a Cube use to say. Power BI Desktop October 2018 update brings in quite a few updates, with one thing being my favorite as I always do/check it manually when working with new data: Data Profiling. For more info and how to enable it, visit … Continue reading Power BI Data Profiling – distinct vs unique
Just: "Wow, this is nice!" Via: http://radacad.com/data-science-virtual-machine Additional info: https://docs.microsoft.com/en-us/azure/machine-learning/data-science-virtual-machine/
Error: Trying to install .NET Framework 3.5 Features on a Windows Server 2016, either through GUI or PowerShell, returns below error (truncated): "The request to add or remove features on the specified server failed. Installation of one or more roles, role services, or features failed. The source files could not be found." Cause: .Net Framework … Continue reading Install-WindowsFeature Web-Net-Ext failed. Source files could not be found.
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
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