topic Re: Dynamic Column Name changed by the selected Year & Month in DAX Commands and Tips

Dynamic Column Name changed by the selected Year & Month

Young_G_Han — Mon, 01 Apr 2024 07:55:31 GMT

Dear Kudos

I am converting an old Excel file report to the BI.

The old Excel file has many customized columns and cells.

One of my missions is to create measures for the following tables.

Above the list is the column header.

The production data refers to many different database files.

So there are many rows that measures are not coming from one table.

Order

Production

Stock

Priority

And so on...

So it is not easy to create the table. Furthermore, I would like to change the month and year based on the date slicer.

For example, if I select 2023/Oct by the date slicer, the report should show

Order

Production

Stock

Priority

Is there a proper approach to make this kind of complicated table by Dax measure?

Re: Dynamic Column Name changed by the selected Year & Month

Dangar332 — Mon, 01 Apr 2024 11:24:02 GMT

hi, Young_G_Han

There no direct posiibility to create such things but you can make a new measure for selected year and make card visual and overlap it in measure or column name

like below
make new measure for selected year only

selected year =

SELECTEDVALUE('Data Date'[Year])

make a new card visual and drag above measure here then resize it and disable catagorical label

overlap it on column where you want to use for selected year total and avg. like below image

here yellow color is card visual after resize it and red color is measure name

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

Re: Dynamic Column Name changed by the selected Year & Month

Young_G_Han — Mon, 01 Apr 2024 23:06:29 GMT

Dear Dangar332

Nice idea. I supposed that would not be easy.

But your idea is reasonable.

Thank you.