Forum Discussion

jkinstler's avatar
jkinstler
Regular Visitor
5 years ago

Time intelligence functions not working unless date filter is included

I am having issues getting the time  intelligence dax funcations to work how I would expect them to.   I am using the AdventureWorks tabular model and created the following simple measure.  Can anyon...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

jkinstler Wow, you are the first person to ever have an issue with DAX Time "Intelligence" functions. JK 🙂

 

You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

 

 

  • jkinstler's avatar
    jkinstler
    Regular Visitor
    5 years ago

    Thanks for the response Greg.  I did find those two posts before posting this.  I am trying to figure out if this is how it is supose to work or if I am some how doing something wrong.  

    Here is a screen shot.  Left as long as there is a year in grid or filter it works.  on the right it doesn't work.  Can I some how add a filter in the dax to have it show data based on last year by default.