Vincent Tseng[DAX] COALESCEWhen using Power BI DAX, often times we encounter a BLANK value, and therefore the result/visual shows “(blank)”, which we don’t like to…1 min read·Aug 24, 2021----
Vincent Tseng[DAX]ALLSELECTED vs. ALLSometimes we would struggle about whether to use ALL or ALLSELECTED. In this article, I will introduce some tips and scenarios to help…3 min read·Jul 30, 2021----
Vincent Tseng[DAX] HASONEVALUE vs HASONEFILTERSometimes it’s confusing for us to decide when to use HASONEVALUE() or HASONEFILTER(). Here we will talk about the difference between the…2 min read·Jul 27, 2021----
Vincent Tseng[DAX] TREATAS()We always want to make our physical relationships from the columns of unique value, or the highest granularity level. In other words, we…3 min read·Jun 17, 2021----
Vincent Tseng[Power BI] The Importance of a Dynamic Calendar TableIn the big data era, 99.9% of data is recorded based on dates. We need dates to look into the improvements of your business compared with…2 min read·Jun 2, 2021----
Vincent Tseng[Power BI] Change Measures/Columns based on SlicerAssuming we would like to make our Power BI report more interactive by allowing users to choose and show any metrics they need in a visual…3 min read·May 30, 2021----
Vincent Tseng[DAX] SWITCHAre you getting tired of writing “if” functions? More specific, are you getting tired of writing a lot of “if” functions with different…2 min read·May 27, 2021----
Vincent Tseng[DAX] EarlierEARLIER is not an easy-to-understand DAX function for Power BI users. I will use some examples to show you how to use EARLIER function.4 min read·May 25, 2021----
Vincent Tseng[Power BI] Running Total by date Or/And by productMost of the time we would like to know the running(cumulative) total of your sales. Here I will show you how to do that in three different…3 min read·May 22, 2021----