In this article, I am going to talk about time intelligence functions in Power BI. We have already touched on a previous example with the fields Date, Total Sales, and Sales Last Year. As you can see, there is no data in Sales LY prior to 2019. In the DAX Formulas Reference Guide, you can
If you need a Power BI time intelligence function that you can use to generate time comparisons over a range of different time frames, then the DATEADD function is the one you’re looking for. You may watch the full video of this tutorial at the bottom of this blog. This, by far, is my go-to
