Create a Date Dimension in Azure SQL Data Warehouse
Most data warehouses and data marts...
PolyBase Is A Picky Eater – Remove Carriage Returns Before Ingesting Text
Update: As Gerhard points out in...
Using Context To Traverse Hierarchies In DAX
My friend and coworker Melissa Coates (aka...
BimlScript – Get to Know Your Control Nuggets
This is post #2 of my BimlScript...
BimlScript – Get to Know Your Code Nuggets
In BimlScript, we embed nuggets of...
Colorblind Awareness and Power BI KPIs
Update: The ability to change the color...
Trekking through the DAX Jungle In Search of Lost Customers
I like to think I’m proficient...
Creating a Matrix in Power BI With Multiple Values on Rows
This week I was asked to...
Using a Variable to Populate the Query in a Lookup in SSIS
I encountered a situation on my last...