Forum Discussion
Automatic current time date filter
Hi Anonymous ,
I get it.
Please try this measure.
Measure = IF(MAX('Table'[Date])>=EOMONTH(TODAY(),-1)+1&&MAX('Table'[Date])<=TODAY(),1,0)Drag it into the filter and set the show items when the value is 1.
The PBIX file is attached for reference.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi! i also tried that but Power BI only limits itself to showing the data of only 1 day which is the present and i need to also show the info of past days within the present month, for example, now we are in may 10, so i need to show the info of may 10 and also 9,8,7,5... and all the way back to day 1, and repeat this with every month, working with 1 month i'll be okay
Hi Anonymous ,
I get it.
Please try this measure.
Measure =
IF(MAX('Table'[Date])>=EOMONTH(TODAY(),-1)+1&&MAX('Table'[Date])<=TODAY(),1,0)
Drag it into the filter and set the show items when the value is 1.
The PBIX file is attached for reference.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data