Forum Discussion
Dynamic Filter by Today's Period/Date
Sample File https://drive.google.com/file/d/1lysTi_VPXBGhGB1WUF05BDdF6DWOxUhE/view?usp=sharing I have a date calendar table, and my Sales Table has an "Accounting Period" and "Shipped Date" Co...
Anonymous ,
This fine when you want only today
Is Today = if('Date'[Date]=TODAY(),"Yes","NO")
for month till day
Is Today = if('Date'[Date]<=TODAY() && 'Date'[Date]> eomonth(Today(),-1) ,"MTD","NO")