Dynamic Calculated Column Name based on Year Values

[Raman3456]

Hello Everyone,

Name      2021 Count     2022 count         2025 Count

A                 13

B                  3

C                  9

D                  7

I have this data I need to add calculated columns Dynamically -- 2021 count, 2022 count .... 2025 count on every year .

Will it be possible in Power BI?

Regards,

Raman PC

[DataNinja777 · Accepted solution]

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,

[v-yangliu-msft · Accepted solution]

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

[DataNinja777 · Accepted solution]

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,