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


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


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


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


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


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


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


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


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


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...
Jihwan Kim
Sep 30, 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...
Jihwan Kim
Sep 27, 20222 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...
Jihwan Kim
Sep 23, 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...
Jihwan Kim
Sep 19, 20223 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...
Jihwan Kim
Sep 14, 20222 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...
Jihwan Kim
Sep 12, 20223 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...
Jihwan Kim
Sep 9, 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...
Jihwan Kim
Sep 7, 20222 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...
Jihwan Kim
Sep 6, 20223 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 (...
Jihwan Kim
Sep 3, 20222 min read
Â
Â
Â


Create a calculated table that contains active employees on each date, using GENERATE in Power BI
In this writing, I want to share how I try to create a caluclated table that shows who are active employees on each date in Power BI....
Jihwan Kim
Sep 2, 20222 min read
Â
Â
Â


NATURALINNERJOIN vs. TREATAS in Power BI
In this writing, I want to share how it is different when using NATURALINNERJOIN DAX function and TREATAS DAX function in Power BI. In...
Jihwan Kim
Sep 1, 20223 min read
Â
Â
Â
bottom of page