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


WINDOW DAX 함수 사용하여 10,000개 카테고리 분석 - performance issue?
일주일전에 "상위 몇개의 reseller가 전체매울 80%에 기여하는가?" 대한 분석을, 나는 WINDOW DAX 함수를 어떻게 사용하여 분석하는가에 대한 짧은 블로그를 작성했다. 블로그링크: WINDOW DAX Function in Pareto...
Jihwan Kim
Feb 4, 20233 min read
24 views
0 comments


WINDOW DAX Function in Pareto Analysis
In this writing, I want to share how I author a calculated measure using the WINDOW DAX function when describing "How much percentage of...
Jihwan Kim
Jan 29, 20233 min read
235 views
0 comments


나는 어떻게 POWER BI의 WINDOW DAX function을 이해하는가?
이번 블로그는 한글로 작성해볼까 한다. 내가 POWER BI를 한글버전으로 사용하지 않기 때문에 불필요한 영어단어가 한글문장에 많이 포함됨을 이해해 주시길... 이번 블로그에서는 나는 어떤 식으로 WINDOW DAX Function을 이해하고...
Jihwan Kim
Jan 22, 20233 min read
169 views
0 comments


What are your use cases of the SUMMARIZECOLUMNS DAX function in Power BI?
In this writing, I want to ask and learn from readers about your use cases of the SUMMARIZECOLUMNS DAX function in Power BI. But before I...
Jihwan Kim
Jan 15, 20233 min read
1,391 views
0 comments


Line-by-line conditional formatting in a Matrix visualization in Power BI
In this writing, I want to share how I try to conditionally format each line (not by all numbers resulted by the measure) in a matrix...
Jihwan Kim
Jan 9, 20232 min read
197 views
0 comments
![The situation that I add a [Sales] column by writing [Qty] X [Unit price] in Power Query Editor](https://static.wixstatic.com/media/64d1a1_91d3297fd40745f281dd7fbc91494b8e~mv2.png/v1/fill/w_333,h_250,fp_0.50_0.50,q_35,blur_30,enc_avif,quality_auto/64d1a1_91d3297fd40745f281dd7fbc91494b8e~mv2.webp)
![The situation that I add a [Sales] column by writing [Qty] X [Unit price] in Power Query Editor](https://static.wixstatic.com/media/64d1a1_91d3297fd40745f281dd7fbc91494b8e~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_avif,quality_auto/64d1a1_91d3297fd40745f281dd7fbc91494b8e~mv2.webp)
The situation that I add a [Sales] column by writing [Qty] X [Unit price] in Power Query Editor
In this writing, I want to share when I decide to add a column in Power Query Editor, instead of writing a DAX measure in the Power BI...
Jihwan Kim
Jan 1, 20233 min read
196 views
0 comments


When do I use INDEX DAX function in Power BI?
In this writing, I want to share when I try using INDEX DAX function in Power BI. Recently (December 2022), there were three DAX...
Jihwan Kim
Dec 19, 20223 min read
569 views
0 comments


WINDOW DAX function in Power BI
In this writing, I want to share when may be the case I want to use the WINDOW DAX function in Power BI. In December 2022 Power BI...
Jihwan Kim
Dec 16, 20222 min read
801 views
0 comments


The problem that I face when connecting Dynamics 365 to Power BI
In this writing, I want to share my current problem, and ask a question about how to solve this problem. I have a simple solution to this...
Jihwan Kim
Dec 12, 20223 min read
126 views
0 comments


What I do when I configure direct query mode and aggregations tables in Power BI
In this short writing, I want to share what I do and check when configuring aggregations tables with direct query mode datamodel in Power...
Jihwan Kim
Dec 2, 20222 min read
230 views
0 comments


What I do as step one in DAX Studio to enhance DAX Measures Performance
In this writing, I want to share how I utilize DAX Studio to check & fix measures and enhance performance. This conveys what I do as a...
Jihwan Kim
Nov 21, 20223 min read
983 views
1 comment


Relationships between Field Parameters in Power BI. Don't let Field Parameters tables stand alone.
In this writing, I want to share how I use Field Parameter tables in my Power BI reports. Field Parameters feature came out to the world...
Jihwan Kim
Nov 14, 20223 min read
1,111 views
1 comment


Getting a recursive type column in Power Query Editor in Power BI
In this writing, I want to share how I try to solve questions that ask about getting recursive-type results in Power BI. I sometimes face...
Jihwan Kim
Nov 11, 20223 min read
228 views
0 comments


LASTNONBLANK & LASTNONBLANKVALUE DAX function in Power BI
In this writing, I want to share how I use LASTNONBLANK and LASTNONBLANKVALUE DAX functions, or how I do not use those to get the same &...
Jihwan Kim
Nov 7, 20224 min read
149 views
0 comments


TOPN DAX function with Pie chart in Power BI
In this writing, I want to share how I use pie chart in my Power BI report, even if some other Power BI authors do not prefer to use the...
Jihwan Kim
Oct 31, 20222 min read
28 views
0 comments


Incremental refresh configuration in Power BI
In this writing, I want to share what I consider when configuring incremental refresh in Power BI. Most of cases, I failed or got doubt...
Jihwan Kim
Oct 25, 20223 min read
193 views
0 comments


Two roles for one user - RLS (Row Level Security) in Power BI
In the previous blog post, I explained how to implement RLS and OLS (Object Level Security) at the same time for one user in one dataset...
Jihwan Kim
Oct 20, 20222 min read
195 views
0 comments


When can I use OFFSET DAX function in Power BI
In this writing, I like to share what I have learned about OFFSET DAX function, that recently came out to the world, but not yet...
Jihwan Kim
Oct 14, 20222 min read
516 views
0 comments


When to build a dashboard in Power BI service?
In this writing, I like to share when I need to build a dashboard in Power BI service, instead of just sharing reports. Situation In one...
Jihwan Kim
Oct 12, 20222 min read
24 views
0 comments


Virtual relationship by utilizing DAX, in Power BI
In this blog post, I want to share how I create a virtual relationship by using DAX formula when no physical relationships were found....
Jihwan Kim
Oct 5, 20223 min read
304 views
0 comments
bottom of page