The Fill Down Hierarchies -Generic Solutions

The Fill Down Hierarchies -Generic Solutions

Follow @gilra In today’s blog post, I share the generic solutions for the Fill Down challenge that I posted here. As you recall, we had a table of backlog items with three levels of hierarchies (Scenario, Feature and Backlog Item). In each row, the source data...
Automatic Detection of Column Types in #PowerQuery

Automatic Detection of Column Types in #PowerQuery

Follow @gilra Working with column types can be challenging in Power Query. The default conversion of types may not always work well for you, and may create future refresh errors, when the column names change. I have blogged about it in details here, and usually...