Forum Discussion

CrisNep's avatar
CrisNep
Frequent Visitor
1 year ago
Solved

Year Function

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.

Need Help
  • muhammad_786_1's avatar
    muhammad_786_1
    1 year ago

    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's avatar
    Anonymous
    1 year ago

    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.

2 Replies

  • muhammad_786_1's avatar
    muhammad_786_1
    Solution Supplier
    1 year ago

    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's avatar
    Anonymous
    Not applicable
    1 year ago

    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.