Forum Discussion

CrisNep's avatar
CrisNep
Frequent Visitor
2 years 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 appreci...
Need Help
  • muhammad_786_1's avatar
    muhammad_786_1
    2 years 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
    2 years 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.

Anonymous's avatar
Anonymous
Not applicable
2 years 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.