Forum Discussion
Remove values after current date from previous years
The goal is to remove values after current date (most recent in this sample) from previous years for comparison purposes. Any insights?
Hi diogobraga2
if i understand you correct you can create a new simple table
Table = FILTER(
ALL('Table 1');
'Table1'[Date]<=today()
)
do not hesitate to give a kudo to useful posts and mark solutions as solution