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


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
196 views
0 comments

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
205 views
0 comments

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
248 views
0 comments

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
64 views
1 comment

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
265 views
0 comments

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
683 views
0 comments

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
367 views
0 comments

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
157 views
0 comments

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
400 views
0 comments

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
35 views
0 comments

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
293 views
0 comments

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
69 views
1 comment

Marketing Campaign Costs Analysis, in Power BI
Marketing Campaign Costs Analysis, in Power BI
Jihwan Kim
Feb 27, 20212 min read
96 views
0 comments

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
42 views
0 comments

Displaying Currency by utilizing Tabular Editor, in Power BI
In this writing, I want to share how I display currency together with a sum amount in a matrix visualization, in Power BI.
Jihwan Kim
Feb 19, 20213 min read
61 views
0 comments

Cohort Analysis in Power BI, by telling the story.
I want to share how I created my own story and how I used the sample data when processing the Cohort Analysis, in Power BI.
Jihwan Kim
Feb 17, 20215 min read
254 views
0 comments

SANDVIK and its competitors stock price trends analysis, in Power BI.
In this writing, I want to share what I have learned by researching Sandvik's and its competitors' recent one-year stock market prices. I...
Jihwan Kim
Feb 16, 20212 min read
53 views
0 comments

Maven Marketing Challenge, by Power BI. & How to get a zip file from WEB and unzip in Power Query.
In this blog post, I want to share how I analyzed the data that is shared by Maven Analytics for mavenmarketingchallenge.
Jihwan Kim
Feb 11, 20214 min read
301 views
0 comments
bottom of page