Previous Year YTD formula

if [Order Date] <= [date]-365
and DATEPART('year',DATEADD('month',12,[Order Date])) = DATEPART('year',DATEADD('month',12,[date]-365))
then [Sales]
end

Date is the parameter here..

Option 2:

sum(if year([Order Date]) = year([date])-1 and 

[Order Date] <= dateadd('year',-1,[date]) then [Sales] END)

Interview questions -12

1. Different phases considered while building the dashboard ?

2. Challenges faced while building the dashboard ?

3. How do you determine the timeline when you get any request to build a dashboard and justify

4. What are the criteria one should consider to build an efficient dashboard ?