Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |