Time Intelligence Functions

@jmolina,

Yes, you can use the TODAY() function in DAX to return today’s date, and then build time intelligence off of that. For example, YEAR( TODAY() ) will return 2020. You can build it into almost any DAX time intelligence function, e.g., DATESBETWEEN, DATEDIFF, DATEADD, etc.

Here’s the entry for that function in the Enterprise DNA Knowledge Base:

https://info.enterprisedna.co/dax-function-guide/today/

And an example calculating sales from today through end of month:

Hope this is helpful. If you want to post a PBIX, we can work through a more specific solution.

  • Brian