Forum Discussion
hamzashafiq
Kudo Collector
Kudo CollectorFilter Table for Last 12 Months using DAX
Hi Folks,
Can anyone please tell me the DAX formula to filter and duplicate the exisiting table "Table1" for last 12 months using DAX?
Distinct(Filter(Table, Table[Date]> Eomonth(today(),-12)))
or table distinct first , or summarize and select the required columns
2 Replies
- amitchandak
Super User
Distinct(Filter(Table, Table[Date]> Eomonth(today(),-12)))
or table distinct first , or summarize and select the required columns
hamzashafiqamitchandak thank you so much 🙂