Historical Sales and Current Forecast - Past and Future Dates

Once you get used to using it, it really is simple. It’s amazing how easy it makes time intelligence calculations. Other than DATEADD, DATEDIIFF, DATE and the EO series, I almost never need to use any of the myriad of canned time intelligence functions.

So this is just a filter I’d grab in my measures and calculations, or would I use it as a filter on visuals/tables?

That’s one of the beauties of it - it works equally well both ways.

  • Brian
2 Likes