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 "powerbi works" page & "blog" pages for inspiration and generate your own unique insights. Let's embark on this data-driven journey together!
Search


Understanding Conflicts and Smooth Pull Requests in Azure DevOps for Power BI
In this writing, I want to share my experience of altering the same report using different branches and PBIP files, and committing those...
Jihwan Kim
Nov 12, 20234 min read
354 views
0 comments


Learning to Configure Source Control for an Existing Power BI Workspace and Locating the .pbix File
In this writing, I like to share how I learn configuring Source Control and Git Integration for an existing Power BI workspace. Join me...
Jihwan Kim
Nov 5, 20234 min read
466 views
0 comments


Dynamic Dimension Selection: Empowering Power BI Reports with Field Parameters
In this writing, I want to share my journey of learning the creation of a dynamic field parameter for selecting dimensions in Power BI...
Jihwan Kim
Oct 29, 20233 min read
1,240 views
2 comments


How I create Cumulative Sums that resets whenever value is zero
In this blog post, I aim to share my journey of learning how to create a dynamic DAX measure that effectively displays cumulative sums,...
Jihwan Kim
Oct 15, 20233 min read
499 views
0 comments


Commit three times, and revert the second commit. Power BI Version Control in Azure DevOps.
In this writing, I like to share what I have tested when version controlling in Power BI with Azure DevOps. Recently, I could experience...
Jihwan Kim
Jul 23, 20233 min read
434 views
0 comments


PBI Version Control with Git Integration + PBIP + Deployment Pipeline | What setup is good to go?
In this writing, I want to share how I like to set up the Power BI Version Control process with Git Integration configured in workspaces...
Jihwan Kim
Jul 15, 20234 min read
2,543 views
0 comments


Power BI version control and main branch vs. sub branch in Azure DevOps.
In this writing, I like to share how I create a simple "Pipeline" and create a "Release" in Azure DevOps to publish Power BI Dataset and...
Jihwan Kim
Jul 13, 20234 min read
969 views
0 comments


Power BI Development Version Control with Azure DevOps - Start to practice using pbip file.
In this writing, I like to share how I learn to create a project in Azure DevOps in order to version control Power BI files, and in order...
Jihwan Kim
Jul 8, 20233 min read
2,347 views
0 comments


Performance comparison between Import vs. Direct Query vs. Direct Lake, in Fabric and Power BI
In this writing, I like to share how I compare the performance between Import, Direct Query, and Direct Lake modes, in Fabric (and in...
Jihwan Kim
Jun 24, 20232 min read
963 views
0 comments


Creating a Direct Lake connection in Power BI Desktop, and how to verify it?
In this writing, I want to share how I create Direct Lake Dataset in Fabric to connect to Power BI Desktop, and how to check and verify...
Jihwan Kim
Jun 18, 20232 min read
360 views
0 comments


When do I use the MATCHBY DAX function in Power BI
In this writing, I want to share how I started to learn and practice the MATCHBY DAX function that came out in May 2023. Link to...
Jihwan Kim
May 28, 20231 min read
362 views
0 comments


Restore a connection in Deployment Pipeline, in Power BI
In this writing, I like to share what I struggled with when working with datasets and reports in the Deployment Pipeline in Power BI, and...
Jihwan Kim
May 13, 20233 min read
246 views
0 comments


Dynamic format string in Power BI - How I start to use it in my report.
In this writing, I like to share how I started using the Dynamic Format String feature in Power BI, which was recently added as a preview...
Jihwan Kim
Apr 30, 20233 min read
291 views
0 comments


The Surprising Benefits of Choosing RANK DAX Over RANKX for Power BI: My Personal Experience
In this writing, I like to share my recent discoveries regarding one of the two new DAX functions. Recently, I saw two new DAX functions...
Jihwan Kim
Apr 15, 20234 min read
3,594 views
0 comments


My Top 3 Right-Clicks in Power BI Desktop
In this writing, I'll be sharing my top three favorite right clicks in Power BI Desktop, as well as a bonus suggestion for additional...
Jihwan Kim
Apr 2, 20233 min read
341 views
0 comments


Analyzing 50,000 customers in Power BI: Performance problem
In this writing, I want to present how to create DAX measures for producing an insight when a list of 50,000 customers is given and asked...
Jihwan Kim
Mar 19, 20233 min read
508 views
0 comments
![파워비아이 period분석: [Start_Date] column & [End_Date] column in the Project table, in Power BI](https://static.wixstatic.com/media/64d1a1_16713b1f59644b3e8eeecea504b77ca4~mv2.png/v1/fill/w_333,h_250,fp_0.50_0.50,q_35,blur_30,enc_avif,quality_auto/64d1a1_16713b1f59644b3e8eeecea504b77ca4~mv2.webp)
![파워비아이 period분석: [Start_Date] column & [End_Date] column in the Project table, in Power BI](https://static.wixstatic.com/media/64d1a1_16713b1f59644b3e8eeecea504b77ca4~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_avif,quality_auto/64d1a1_16713b1f59644b3e8eeecea504b77ca4~mv2.webp)
파워비아이 period분석: [Start_Date] column & [End_Date] column in the Project table, in Power BI
이 블로그에서는, [Start_Date] column 과 [End_Date] column 이 존재하는 table을 분석할 때, 나는 어떤 생각을 가지고 Power BI analysis를 시작하는지에 대해서 공유하고자 한다. DAX...
Jihwan Kim
Mar 12, 20233 min read
32 views
0 comments


Utilizing the LINESTX DAX function with a virtual table in Power BI
After I posted the short blog post, LINESTX DAX in Power BI - How I start to play with it (jihwankimcscp.wixsite.com, Alexis Olson...
Jihwan Kim
Feb 26, 20233 min read
1,239 views
0 comments


LINESTX DAX in Power BI - How I start to play with it
In this writing, I want to share how I started playing with the new DAX function, released a few days ago, LINESTX in Power BI. The...
Jihwan Kim
Feb 19, 20233 min read
693 views
0 comments


Where can I check incremental refresh is correctly done? Power BI Premium
In my previous blog post, Incremental refresh configuration in Power BI (jihwankimcscp.wixsite.com), I shared what I usually check when...
Jihwan Kim
Feb 11, 20232 min read
196 views
0 comments
bottom of page