Forum Discussion
diogobraga2
Helper IV
Helper IVRemove 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?
az38
Community Champion
Community ChampionHi 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