Forum Discussion
Year Function
- 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 - Anonymous1 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.
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.