Search code examples
powerbidaxbusiness-intelligence

DAX formula for all Customer Orders older than 60 days


Table contain columns like: (Customer_Id, Customer_Name, Customer_Category, Last_Order_Date) I need in PowerBI, DAX formula to show all customers which order is older than 60 days from today's date.


Solution

  • Measure = COUNTROWS(FILTER('BC Customer', DATEDIFF([Last_Order_Date], TODAY(), DAY) > 60))