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 "blog" page for inspiration and generate your own unique insights. Let's embark on this data-driven journey together!
Search


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


TopN and Breaking Ties, in Power BI
In this writing, I want to share how I use TOPN DAX function in order to only visualize the most wanted categories, instead of...
Jihwan Kim
Sep 1, 20222 min read


Conditional formatting in matrix/table visualization - Power BI
In this writing, I want to share in detail how I create a measure in order to show conditionally format matrix/table visualization in...
Jihwan Kim
Aug 31, 20222 min read


Jordan vs LeBron Challenge, in Power BI, by Maven Analytics.
In this writing, I want to share how I analyzed and what I have found using Michael Jordan’s and LeBron Jame’s data posted by and thanks to
Jihwan Kim
Mar 6, 20212 min read


Analyzing my professional experiences in Power BI
In this writing, I want to share how I analyzed my professional experiences in Power BI, and what I have planned for my future.
Jihwan Kim
Feb 28, 20212 min read


Marketing Campaign Costs Analysis, in Power BI
Marketing Campaign Costs Analysis, in Power BI
Jihwan Kim
Feb 27, 20212 min read


Worldwide Trading Export & Import values (USD) & volumes (kg) analysis, in Power BI
Worldwide Trading Export & Import values (USD) & volumes (kg) analysis, in Power BI
Jihwan Kim
Feb 22, 20213 min read
bottom of page