top of page
flow analysis
designed by Jihwan
Unlock the Power of Data with Dynamic Insights: Dive deep into comprehensive data flow analysis with Microsoft Power BI and Fabric. Experience the magic firsthand by requesting a personalized demonstration of my analysis reports, or explore the "blog" page for inspiration and generate your own unique insights. Let's embark on this data-driven journey together!
Search


Exploring DAX UDFs — Challenges, Learnings, and What Comes Next
In this writing, I’d like to share how I started to learn and create my own DAX UDF (User Defined Function) library , the pain points I’ve faced while trying to make the functions as general as possible, and how I plan to take the next steps forward. You can explore the project here: jihwankimdata/dax_udf_library How It Started Like many Power BI developers, I’ve written the same logic dozens of times — percentage growth, variance analysis, ranking, or window calculations — s
Jihwan Kim
7 hours ago4 min read
Â
Â
Â


Reusable DAX logic with User Defined Functions (UDFs) – a new paradigm for semantic modeling
Introduction DAX User Defined Functions (UDFs) – introduced in the Power BI September 2025 release – let you encapsulate complex logic into named, parameterized functions that can be reused across measures and models. Power BI September 2025 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI Unlike calculation groups, UDFs accept parameters and nest other functions, paving the way for cleaner, more maintainable semantic models. Enterprise scenario:  Let's assume,
Jihwan Kim
Oct 186 min read
Â
Â
Â


What TMDL View Means for Model Versioning & Enterprise Workflows
In this writing, I’d like to share how I’ve been exploring TMDL (Tabular Model Definition Language)  since it was in preview — and why...
Jihwan Kim
Oct 115 min read
Â
Â
Â


Editing Semantic Models in the Service + TMDL View & Best Practices
In this writing, I’d like to share how I started learning to edit semantic models directly in the Power BI service  and how TMDL (Tabular...
Jihwan Kim
Oct 44 min read
Â
Â
Â


Using Semantic Model Refresh Templates & Fabric Data Pipelines for Scalable Model Maintenance
Why I Started Looking at Refresh Templates For years, I’ve learned and worked with refresh schedules in Power BI. At a small scale,...
Jihwan Kim
Sep 213 min read
Â
Â
Â


Stop Repeating DAX: Reusable Time Intelligence Calculation Group with TMDL
In this writing, I’d like to share how I've learned to dramatically accelerate one of the most common and repetitive tasks in Power BI...
Jihwan Kim
Aug 35 min read
Â
Â
Â


Why Sunsetting Default Semantic Models is Fabric's Best Decision Yet
In this writing, I’d like to share what I have learned from a recent Microsoft Fabric announcement that, in my opinion, is one of the...
Jihwan Kim
Jul 263 min read
Â
Â
Â


DAX: Visual Calculations and Measures
In this writing, I’d like to share how I learn to navigate the evolving world of DAX. In an era dominated by AI and low-code solutions,...
Jihwan Kim
Jul 205 min read
Â
Â
Â


Taming the Beast: From 4-Hour Refreshes to Fast Insights with Power BI and Microsoft Fabric
I. Introduction: The All-Too-Common Incremental Refresh Headache In this writing, I’d like to share how I approach a frustratingly common...
Jihwan Kim
Jul 1313 min read
Â
Â
Â


.gitignore for Power BI Projects: A Simple Guide for the Modern BI Developer
In this writing, I’d like to share how I learned and understood one of the most important—and often overlooked—files I encountered as I...
Jihwan Kim
Jul 54 min read
Â
Â
Â


Start Coding: A Modern Power BI Workflow with TMDL and VS Code
In this writing, I’d like to share how I am evolving my Power BI development process. For years, building semantic models has been a...
Jihwan Kim
Jun 295 min read
Â
Â
Â


Leveraging OFFSET for Dynamic Ranking and Related Analytical Patterns Power BI: A Deep Dive Beyond Time Intelligence
In this writing, I like to share how I learned understanding and writing OFFSET DAX function in Power BI. OFFSET function (DAX) - DAX |...
Jihwan Kim
Jun 223 min read
Â
Â
Â


Unlocking Next-Level Productivity with Power BI's TMDL View and AI
Introduction: A New Chapter in My Power BI Development Journey In this writing, I'd like to share my journey with a feature that has...
Jihwan Kim
Jun 148 min read
Â
Â
Â


Cohort Analysis in Power BI: Mastering WINDOW and PARTITIONBY
By Jihwan Kim In this writing, I like to share how I learned to tackle one of the more insightful business analyses – cohort analysis,...
Jihwan Kim
Jun 56 min read
Â
Â
Â


INFO.DAX + Fabric Notebooks Find Unused Columns
Measure Bloat You Can’t See—But Still Pay For Introduction In this writing, I like to share how I learned to uncover hidden VertiPaq...
Jihwan Kim
May 314 min read
Â
Â
Â


Direct Lake vs. Import vs. Direct Lake + Import: Learn Building Three Storage Patterns That Scale
Introduction In this writing, I like to share how I learned to create three distinct storage patterns for Power BI semantic models—...
Jihwan Kim
May 253 min read
Â
Â
Â


From Zero → Lakehouse: Loading AdventureWorks Sample into Microsoft Fabric (Notebook-Only)
In this writing, I like to share how I learn to populate a clean Fabric Lakehouse —AdventureWorks— using nothing but Spark notebooks. 1...
Jihwan Kim
May 171 min read
Â
Â
Â


The Power of VAR in DAX: Enhancing Performance and Readability
In this writing, I like to share how I learned to leverage the VAR in DAX to improve both the performance and readability of my Power BI...
Jihwan Kim
May 103 min read
Â
Â
Â


The Hidden Cost of Auto Date/Time in Large Power BI Models
Why performance and data model bloat may be silently hurting Power BI developments. In this writing, I like to share how I learn to...
Jihwan Kim
May 54 min read
Â
Â
Â


Power BI Style Presets: Visual Consistency and Efficiency
In this writing, I'd like to share how I started learning to configure stylePresets  in Power BI and why it’s an exciting breakthrough...
Jihwan Kim
Apr 275 min read
Â
Â
Â
bottom of page