topic Re: Dynamic Calculated Column Name based on Year Values in DAX Commands and Tips

Dynamic Calculated Column Name based on Year Values

Raman3456 — Fri, 03 Jan 2025 10:42:07 GMT

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

Re: Dynamic Calculated Column Name based on Year Values

DataNinja777 — Fri, 03 Jan 2025 15:28:28 GMT

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,

Re: Dynamic Calculated Column Name based on Year Values

Anonymous — Mon, 06 Jan 2025 06:49:54 GMT

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