Forum Discussion
Current Month Button
This can be achieved using a DAX formula and creating a calculated column, or using a measure and creating a button that selects the current month when clicked. Here is an example of a DAX formula for a calculated column that returns the current month:
=IF(MONTH(TODAY())=MONTH([Date]),1,0)
In this formula, the TODAY() function returns the current date, and the MONTH function returns the current month number. The IF function checks if the current month number is equal to the month number of the date in the [Date] column, and returns 1 if it is, and 0 otherwise.
Once you have created the calculated column, you can use it to create a slicer that filters the report to only show the current month. You can also create a button that toggles the selection in the slicer, so that when it is clicked, it selects the current month.
This can be achieved using a DAX formula and creating a calculated column, or using a measure and creating a button that selects the current month when clicked. Here is an example of a DAX formula for a calculated column that returns the current month:
=IF(MONTH(TODAY())=MONTH([Date]),1,0)
In this formula, the TODAY() function returns the current date, and the MONTH function returns the current month number. The IF function checks if the current month number is equal to the month number of the date in the [Date] column, and returns 1 if it is, and 0 otherwise.
Once you have created the calculated column, you can use it to create a slicer that filters the report to only show the current month. You can also create a button that toggles the selection in the slicer, so that when it is clicked, it selects the current month.
Hi, I have this problem related to this issue. My dashboard has KPIs that show variations compared to the previous year. When I select the filter with the current month, the variations are empty since my date dimensional table would only be showing the current month. Any solution to this? Thanks 🙂
