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


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
Â
Â
Â


Understanding the EARLIER and EARLIEST DAX Functions in Power BI – Beyond Their English Meaning
In this writing, I like to share how I started to learn about the EARLIER and EARLIEST DAX functions, which I felt quite confusing at...
Jihwan Kim
Mar 313 min read
Â
Â
Â


Finding Table.RemoveColumns function in M Code in Power Query Editor Using TMDL View
In this blog post, I’d like to share how I learned to find where Table.RemoveColumns function in M code is used in Power Query Editor and...
Jihwan Kim
Mar 94 min read
Â
Â
Â


Leveraging the TMDL View Feature in VSCode with GitHub Copilot: my experience
In this writing, I want to share how I start to use TMDL View feature with GitHub Copilot in VSCode. As a Power BI developer, staying...
Jihwan Kim
Feb 94 min read
Â
Â
Â


Getting Started with TMDL View in Power BI: My Experience
In this writing, I want to share how I start to use the TMDL (Tabular Model Definition Language) view in Power BI. This isn’t a deep dive...
Jihwan Kim
Feb 23 min read
Â
Â
Â


How I learn WINDOW DAX function in Power BI
In this writing I like to share how I learned WINDOW DAX function in Power BI. Over the past few months, I’ve had the opportunity to work...
Jihwan Kim
Jan 114 min read
Â
Â
Â
bottom of page