Forum Discussion
filter by today's date
You need to have some date on which you want to filter the Today's value. What do you mean by Today's value without a date?
Hi there,
Have a look at the TODAY() Function.
https://support.office.com/en-us/article/today-function-5eb3078d-a82c-4736-8930-2f51a028fdd9You need to try something like this
calculate(count(form[id]),filter(form,form[publish_date]=today(),form[_date]=today()))In case you want to filter using a slicer. Create a date dimension table and join it with all dates. Other than one join, all joins will be inactive.
Date calendar
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
Example how to change the date in a formula
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
