Parth Lad

@parthlad

Data Management Analyst

Toronto, OntarioJoined November 2023

About

I'm a data analyst who loves finding insights from numbers and visualizing them. I write about Data Analytics, Data Engineering, Power BI, and DAX on Medium & Hashnode.

Follow me for more!✌️😉

Available for

building dashboards, creating end-to-end data solution.

Parth Lad's blogs

NavigateData: Your Gateway to Data Excellence - Expert Insights, Tools, Power BI, Python, Spark, SQL Solutionsthenavigatedata.com/blog16 posts

Articles Comments1

Recently published

PLParth Ladthenavigatedata.comJul 1, 2025 · 5 min read

Introducing FabricFlow: Code-First Data Pipelines in Microsoft Fabric

It’s been a while since my last post — I’ve been heads-down working on a few personal projects. One of them is finally ready to share: FabricFlow v0.1.0. I have been working with Microsoft Fabric since the day it launched. It has changed significantl...

0

PLParth Ladthenavigatedata.comJun 22, 2024 · 8 min read

Avoid Repetitive Steps in MS Fabric Dataflow Gen2 with Custom Functions

While working with Dataflow Gen2 or Power BI, If you keep finding yourself needing to apply the same transformations to different queries or values, making a custom function in Power Query can save you loads of time. It's like using SQL functions to ...

0

PLParth Ladthenavigatedata.comJun 17, 2024 · 3 min read

A Quick Guide to Configuring Data Destinations in Bulk with MS Fabric Dataflow Gen2

In this blog post, we'll dive into how you can hook up Dataflows to different data sources, use Dataflow Gen2 for data transformations, and manage data destinations across various Microsoft Fabric services. What is Dataflow Gen2? Dataflow Gen2 is the...

0

PLParth Ladthenavigatedata.comJun 3, 2024 · 4 min read

Power BI DAX : Context Explained in Minutes

In Power BI DAX, context is all about the environment that affects how a formula is calculated. It decides which subset of data is used for the calculation and lets you do dynamic analysis based on what users do. There are two main types of context i...

0

PLParth Ladthenavigatedata.comDec 4, 2023 · 3 min read

Power Query's Missing IN Operator

The IN operator is a common feature in programming languages, allowing users to check if a value exists within a specified list. While Power Query M doesn't have a built-in IN operator, we can still achieve the same functionality using alternative me...

0

Parth Lad

About

Available for

Parth Lad's blogs

Recently published

Introducing FabricFlow: Code-First Data Pipelines in Microsoft Fabric

Avoid Repetitive Steps in MS Fabric Dataflow Gen2 with Custom Functions

A Quick Guide to Configuring Data Destinations in Bulk with MS Fabric Dataflow Gen2

Power BI DAX : Context Explained in Minutes

Power Query's Missing IN Operator

Search Hashnode

Parth Lad

About

Available for

Parth Lad's blogs

Recently published

Introducing FabricFlow: Code-First Data Pipelines in Microsoft Fabric

Avoid Repetitive Steps in MS Fabric Dataflow Gen2 with Custom Functions

A Quick Guide to Configuring Data Destinations in Bulk with MS Fabric Dataflow Gen2

Power BI DAX : Context Explained in Minutes

Power Query's Missing IN Operator