Power BI Analysis | Supply chain flow

When do I use the MATCHBY DAX function in Power BI

Jihwan Kim

May 28, 20231 min read

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

345 views0 comments

Restore a connection in Deployment Pipeline, in Power BI

Jihwan Kim

May 13, 20233 min read

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

207 views0 comments

Dynamic format string in Power BI - How I start to use it in my report.

Jihwan Kim

Apr 30, 20233 min read

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

274 views0 comments

The Surprising Benefits of Choosing RANK DAX Over RANKX for Power BI: My Personal Experience

Jihwan Kim

Apr 15, 20234 min read

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

2,883 views0 comments

My Top 3 Right-Clicks in Power BI Desktop

Jihwan Kim

Apr 2, 20233 min read

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

340 views0 comments

Analyzing 50,000 customers in Power BI: Performance problem

Jihwan Kim

Mar 19, 20233 min read

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

502 views0 comments

파워비아이 period분석: [Start_Date] column & [End_Date] column in the Project table, in Power BI

Jihwan Kim

Mar 12, 20233 min read

파워비아이 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...

32 views0 comments

Utilizing the LINESTX DAX function with a virtual table in Power BI

Jihwan Kim

Feb 26, 20233 min read

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

1,164 views0 comments

Jihwan Kim

Feb 19, 20233 min read

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

647 views0 comments

Where can I check incremental refresh is correctly done? Power BI Premium

Jihwan Kim

Feb 11, 20232 min read

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

191 views0 comments

WINDOW DAX 함수 사용하여 10,000개 카테고리 분석 - performance issue?

Jihwan Kim

Feb 4, 20233 min read

WINDOW DAX 함수 사용하여 10,000개 카테고리 분석 - performance issue?

일주일전에 "상위 몇개의 reseller가 전체매울 80%에 기여하는가?" 대한 분석을, 나는 WINDOW DAX 함수를 어떻게 사용하여 분석하는가에 대한 짧은 블로그를 작성했다. 블로그링크: WINDOW DAX Function in Pareto...

23 views0 comments

Jihwan Kim

Jan 29, 20233 min read

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

225 views0 comments

나는 어떻게 POWER BI의 WINDOW DAX function을 이해하는가?

Jihwan Kim

Jan 22, 20233 min read

나는 어떻게 POWER BI의 WINDOW DAX function을 이해하는가?

이번 블로그는 한글로 작성해볼까 한다. 내가 POWER BI를 한글버전으로 사용하지 않기 때문에 불필요한 영어단어가 한글문장에 많이 포함됨을 이해해 주시길... 이번 블로그에서는 나는 어떤 식으로 WINDOW DAX Function을 이해하고...

165 views0 comments

What are your use cases of the SUMMARIZECOLUMNS DAX function in Power BI?

Jihwan Kim

Jan 15, 20233 min read

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

1,181 views0 comments

Line-by-line conditional formatting in a Matrix visualization in Power BI

Jihwan Kim

Jan 9, 20232 min read

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

196 views0 comments

The situation that I add a [Sales] column by writing [Qty] X [Unit price] in Power Query Editor

Jihwan Kim

Jan 1, 20233 min read

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

192 views0 comments

When do I use INDEX DAX function in Power BI?

Jihwan Kim

Dec 19, 20223 min read

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

484 views0 comments

Jihwan Kim

Dec 16, 20222 min read

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

774 views0 comments

The problem that I face when connecting Dynamics 365 to Power BI

Jihwan Kim

Dec 12, 20223 min read

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

116 views0 comments

What I do when I configure direct query mode and aggregations tables in Power BI

Jihwan Kim

Dec 2, 20222 min read

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

212 views0 comments

flow analysis

designed by Jihwan

© 2024 by Jihwan Kim from The Netherlands

email: data@flowanalysis.co