Dynamic Calculated Column Name based on Year Values

Hi Raman3456 ,

 

Yes. It is easily doable in Power BI.  

Create a Calendar table using CALENDAR and link it to your data table by year. Use a Matrix visual with Name in Rows, Year from the Calendar table in Columns, and your Count in Values for a dynamic, scalable solution.

Best regards,

Thanks for the reply from DataNinja777 , please allow me to provide another insight: 
Hi  Raman3456 ,

 

Here are the steps you can follow：

1. In Power Query – Add Column – Date – Year -- Year.

2. Select [Year] – Tramsform – Pivot Column.

Values Column – [Date]

Aggregate Value Function – Count(ALL)

3. Result:

 

Best Regards,

Liu Yang

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