Forum Discussion
One date filter for multiple date columns in one table
NickEccles , you can join both dates one active and another one inactive and use userelation to activate one
Refer this blog how to do
HI NickEccles,
Did your date field succeed recognize as date hierarchy? If this is a case, you can expand the hierarchy fields and extract the year and month fields to create slicers.
If not, you can also check the auto date/time option or create calculated columns with month and year function to extract year and month values form date field.
Apply auto date/time in Power BI Desktop
Function Description YEAR Returns the year of a date as a four-digit integer in the range 1900-9999. MONTH Returns the month as a number from 1 (January) to 12 (December). Regards,
Xiaoxin Sheng
HI NickEccles,
Did your date field succeed recognize as date hierarchy? If this is a case, you can expand the hierarchy fields and extract the year and month fields to create slicers.
If not, you can also check the auto date/time option or create calculated columns with month and year function to extract year and month values form date field.
Apply auto date/time in Power BI Desktop
| Function | Description |
| YEAR | Returns the year of a date as a four-digit integer in the range 1900-9999. |
| MONTH | Returns the month as a number from 1 (January) to 12 (December). |
Regards,
Xiaoxin Sheng