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
![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_auto/64d1a1_91d3297fd40745f281dd7fbc91494b8e~mv2.webp)
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...
195 views0 comments

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...
512 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...
792 views0 comments

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...
122 views0 comments

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...
213 views0 comments

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...
975 views1 comment

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...
1,024 views1 comment

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...
216 views0 comments

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 &...
131 views0 comments

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...
26 views0 comments

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...
191 views0 comments

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...
195 views0 comments

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...
489 views0 comments

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

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....
259 views0 comments

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...
44 views0 comments

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...
309 views0 comments

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,537 views0 comments

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...
186 views0 comments


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...
194 views0 comments
bottom of page