Year Function

[CrisNep]

Hi All,

I have a date table and need to extract the year to use as a slicer, similar to what i have here:

Could not find a solution online, please help.

Any advice will be much appreciated.

Thank you.

[muhammad_786_1 · Accepted solution]

Hi @CrisNep 

You just need to create a new calculated column to extract the year like this:

Year = YEAR(DateTable[Date])

After creating this column, you can use it in a slicer to display years.

Please see, if this is what you want.

Best Regards,
Muhammad Yousaf

LinkedIn

[Anonymous · Accepted solution]

Hi @CrisNep 

If you have the date hierachy, you can put the year field of the date hierachy to the slicer directly, you can refer to the following picture.

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[muhammad_786_1 · Accepted solution]

Hi @CrisNep 

You just need to create a new calculated column to extract the year like this:

Year = YEAR(DateTable[Date])

After creating this column, you can use it in a slicer to display years.

Please see, if this is what you want.

Best Regards,
Muhammad Yousaf

LinkedIn