Forum Discussion
Automatically show data set for todays date
There are a few ways to tackle this, one suggestion would be to create a calculated column in power bi, or in power query a custom column. Which compares the date column with today's date. For example the dax calculated column would have the below formula
ColumnName = date = today()
This will return True for todays date, and False for any other date
You can now use this column as a filter on your page, and filter the true value only
If my reply helped you solve the issue, please accept it as the solution 🙂
There are a few ways to tackle this, one suggestion would be to create a calculated column in power bi, or in power query a custom column. Which compares the date column with today's date. For example the dax calculated column would have the below formula
ColumnName = date = today()
This will return True for todays date, and False for any other date
You can now use this column as a filter on your page, and filter the true value only
If my reply helped you solve the issue, please accept it as the solution 🙂