Eric's Blog
  • Blog
  • Tags
  • About Me

Ironman's Lab


Perfect this world with BI

Ironman's Lab


Perfect this world with BI

How to Make Peak Time Analysis based on Records with Start Time and End Time

Tips of using GENERATESERIES

Posted on September 16, 2018

I was just recovered from a really bad flu, luckily I got a fun project after recovery and found some new ideas to blog which is s a compensation to me:) [Read More]
Tags: PowerBI Interval GENERATESERIES

How to Create Custom Function in Power BI

Geocoding in Power BI by connecting API

Posted on July 28, 2018

This blog introduces how to create a “custom function” in Power BI, and I am using geocoding in Power BI by connecting API as a practice. [Read More]
Tags: PowerBI Geocoding Custom Function API

How to Write A Conditional Measure Linked with Slicer

a rolling up model

Posted on June 15, 2018

This blog introduces how to write a conditional measure linked with slicer, which also combines a rolling up model as extra content. The key DAX built-in function is VALUES. [Read More]
Tags: PowerBI Measure DAX Matrix VALUES Slicer

How to Setup Your Own Theme of PowerBI Reports

Tips and Examples of creating JSON File

Posted on May 13, 2018

When you start designing a lot of PowerBI reports, you will meet two questions. Company has a certain color palette for you to use, Or you want to make your own one. The Matrix, Card ,etc. the frequently used visual, you want to make them consistent looking in every report... [Read More]
Tags: PowerBI Theme JSON Color palette

Investment Return Rate Calculation in Power BI

Iteration of Multiplication

Posted on April 29, 2018

Today’s topics including: [Read More]
Tags: PowerBI DAX Iteration PRODUCTX EARLIER INDEX
  • ← Newer Posts
  • Older Posts →
  • Email me
  • GitHub
  • LinkedIn

Eric Dong  •  2024  •  DataInk.com.au

Theme by beautiful-jekyll