Forum Discussion
Previousyear returning blanks
I have tried the 2 measures below and both return blank. The Actuals and Date Table Indep are connected by ME Date and Date, both of which are Date Type. I have tried marking my dates_table Indep as a 'DATE TABLE' and unmarking. Neither works. I have CYTd and PYTD Measures for the same thing, and they work. What could I be missing?
Option 1: Industry $$ PY = calculate(sum('Industry Actuals $$'[Actual]),DATESYTD(DATEADD('Dates_Table Indep'[Date],-1,YEAR),"12/31"))
Option 2: Industry $$ PY = calculate(sum('Industry Actuals $$'[Actual]),PREVIOUSYEAR('Dates_Table Indep'[Date]))
Thanks
2 Replies
- atowriss1
Advocate I
Here is a link w/public data to show how I have it set-up.
- Greg_Deckler
Community Champion
atowriss1 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