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…Aug 24, 2021Aug 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…Jul 30, 2021Jul 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…Jul 27, 2021Jul 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…Jun 17, 2021Jun 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…Jun 2, 2021Jun 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…May 30, 2021May 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…May 27, 2021May 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.May 25, 2021May 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…May 22, 2021May 22, 2021
![[DAX]ALLSELECTED vs. ALL](https://miro.medium.com/v2/resize:fill:160:106/1*r1EYaP9Zy913LJtpTU2z5w.png)
![[DAX]ALLSELECTED vs. ALL](https://miro.medium.com/v2/resize:fill:320:214/1*r1EYaP9Zy913LJtpTU2z5w.png)
![[DAX] TREATAS()](https://miro.medium.com/v2/resize:fill:160:106/1*P3uS2eoA9qX9RX7Kex5puA.png)
![[DAX] TREATAS()](https://miro.medium.com/v2/resize:fill:320:214/1*P3uS2eoA9qX9RX7Kex5puA.png)
![[Power BI] The Importance of a Dynamic Calendar Table](https://miro.medium.com/v2/resize:fill:160:106/1*xC6fFOypM22hXkZtYzFdVw.png)
![[Power BI] The Importance of a Dynamic Calendar Table](https://miro.medium.com/v2/resize:fill:320:214/1*xC6fFOypM22hXkZtYzFdVw.png)
![[Power BI] Change Measures/Columns based on Slicer](https://miro.medium.com/v2/resize:fill:160:106/1*TPVEvsXcl3q4SmH0BHfKnQ.png)
![[Power BI] Change Measures/Columns based on Slicer](https://miro.medium.com/v2/resize:fill:320:214/1*TPVEvsXcl3q4SmH0BHfKnQ.png)
![[DAX] Earlier](https://miro.medium.com/v2/resize:fill:160:106/1*psqgm_TCN0zTpGDN50-vMg.png)
![[DAX] Earlier](https://miro.medium.com/v2/resize:fill:320:214/1*psqgm_TCN0zTpGDN50-vMg.png)
![[Power BI] Running Total by date Or/And by product](https://miro.medium.com/v2/resize:fill:160:106/1*CBoVApTa05V6BD7VCmcv0A.png)
![[Power BI] Running Total by date Or/And by product](https://miro.medium.com/v2/resize:fill:320:214/1*CBoVApTa05V6BD7VCmcv0A.png)