Power BI Analysis | Supply chain flow

What I do as step one in DAX Studio to enhance DAX Measures Performance

Jihwan Kim

Nov 21, 20223 min read

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

969 views1 comment

Relationships between Field Parameters in Power BI. Don't let Field Parameters tables stand alone.

Jihwan Kim

Nov 14, 20223 min read

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

980 views1 comment

Getting a recursive type column in Power Query Editor in Power BI

Jihwan Kim

Nov 11, 20223 min read

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

198 views0 comments

LASTNONBLANK & LASTNONBLANKVALUE DAX function in Power BI

Jihwan Kim

Nov 7, 20224 min read

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

123 views0 comments

TOPN DAX function with Pie chart in Power BI

Jihwan Kim

Oct 31, 20222 min read

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

25 views0 comments

Incremental refresh configuration in Power BI

Jihwan Kim

Oct 25, 20223 min read

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

188 views0 comments

Two roles for one user - RLS (Row Level Security) in Power BI

Jihwan Kim

Oct 20, 20222 min read

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

194 views0 comments

When can I use OFFSET DAX function in Power BI

Jihwan Kim

Oct 14, 20222 min read

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

478 views0 comments

When to build a dashboard in Power BI service?

Jihwan Kim

Oct 12, 20222 min read

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

24 views0 comments

Virtual relationship by utilizing DAX, in Power BI

Jihwan Kim

Oct 5, 20223 min read

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

231 views0 comments

When I fail to convince people about getting value from Power BI report, then I do this!

Jihwan Kim

Sep 30, 20222 min read

When I fail to convince people about getting value from Power BI report, then I do this!

In this writing, I want to share what I usually do when I fail to get attention from people about having great insights from Power BI...

43 views0 comments

Configuring & writing Format String Expression in Tabular Editor, in Power BI

Jihwan Kim

Sep 27, 20222 min read

Configuring & writing Format String Expression in Tabular Editor, in Power BI

In this writing, I want to share how I use Tabular editor in Power BI to change format of a measure that I use in a visualization. How to...

250 views0 comments

Implement both RLS and OLS together in Power BI

Jihwan Kim

Sep 23, 20223 min read

Implement both RLS and OLS together in Power BI

In this writing, I want to share how I implemented both RLS and OLS together in my Power BI report. Most of my Power BI reports, I...

1,516 views0 comments

ADDCOLUMNS + SUMMARIZE VS. SUMMARIZE and Calculated Column VS. Calculated Table in Power BI

Jihwan Kim

Sep 19, 20223 min read

ADDCOLUMNS + SUMMARIZE VS. SUMMARIZE and Calculated Column VS. Calculated Table in Power BI

In this blog post, I want to share what I have incorrectly understood in Power BI. I think there are more than 100 things I still do not...

173 views0 comments

My checkpoints when considering Query Folding in Power Query Editor in Power BI

Jihwan Kim

Sep 14, 20222 min read

My checkpoints when considering Query Folding in Power Query Editor in Power BI

In this blog post, I want to share what I check in Power Query Editor when thinking about Query Folding. There are so many writings about...

189 views0 comments

What are use cases of adding ranking column in Power Query Editor in Power BI

Jihwan Kim

Sep 12, 20223 min read

What are use cases of adding ranking column in Power Query Editor in Power BI

In this blog post, I want to share how I use Power Query Editor in Power BI to get ranking-column and what were the use cases in my...

201 views0 comments

List customers of Top50%-Sales in each month, in Power BI

Jihwan Kim

Sep 9, 20222 min read

List customers of Top50%-Sales in each month, in Power BI

In this blog post, I want to share how I try to write DAX measures in order to show a list of customers who made TOP 50% of sales in each...

241 views0 comments

Running total by reset condition - DAX in Power BI

Jihwan Kim

Sep 7, 20222 min read

Running total by reset condition - DAX in Power BI

In this writing, I want to share my thought process about how I build it up to provide a solution for showing running total that is reset...

64 views1 comment

Create a Function in Power Query for getting Group Running Total

Jihwan Kim

Sep 6, 20223 min read

Create a Function in Power Query for getting Group Running Total

In this writing, I want to share how I learned to create a function in Power Query Editor in Power BI Desktop in order to get Running...

159 views0 comments

Writing CALCULATE two times? => CALCULATE ( CALCULATE (... ) ) in Power BI

Jihwan Kim

Sep 3, 20222 min read

Writing CALCULATE two times? => CALCULATE ( CALCULATE (... ) ) in Power BI

In this writing, I want to share how I will going to find out what will happen if I write, for instance, CALCULATE ( CALCULATE (...

683 views0 comments

flow analysis

designed by Jihwan

© 2024 by Jihwan Kim from The Netherlands

email: data@flowanalysis.co