Forum Discussion
Solved
One date filter for multiple date columns in one table
My first post and apologies as I'm sure I found ther Answer to my question last week but can't find it now ! I'm new to Power BI and trialling it to replace lots of spreadsheets for our Companies KP...
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
NickEccles , you can join both dates one active and another one inactive and use userelation to activate one
Refer this blog how to do