power query to show only one year ago from today power bi code example Example: Power BI date 1 year ago Measure = DATE(YEAR(NOW())-1,MONTH(NOW()), DAY(NOW()-1))