Forum Discussion
DAX Forecast
Hi, Can anyone help me with tips or logic how to show up my Last 1 Year Ago, Last 2 Year Ago, and Forecast in the red square that not show up? Dax that I used: Year {M} Trends_WoW_1_Year =...
lbendlin
Super User
Super UserAssuming your Calender table is a true Dates table (contiguous, covering, marked as Dates table) you can use standard Time Intelligence functions like SAMEPERIODLASTYEAR or DATEADD. That should make your code a bit more concise.