Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
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 anyone explain to me why this returns a blank when I drag it on to the screen with no other filters? Once I add a date filter or include the date in the table it then works. How can I get this to show previous year data based on todays date?
Measure:
Internet Total Sales (PY) = CALCULATE([Internet Total Sales], PREVIOUSYEAR('Date'[Date]) )
@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-TIT...
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.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 3 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 8 | |
| 7 | |
| 6 |