The below video shows how to calculate the moving average or the rolling average and build informative and rich tooltips in Power BI. This is part two of the two-part video series. In the first video, you can learn how to highlight events on a chart timeline using DAX and conditional formatting.
We often use specific value,rangesor some text functions to apply filter on data table fields. In fact, we can also use character functions to achieve some custom filter effect. Here I want to share some scenario about these function usages.
Connecting Dropbox Excel files to Power BI can be a challenging task. As there is no Dropbox connector in Power Bi, here is how I did it. If there is a simpler way, please let me know. I will be happy to update this article with the necessary details.