Dynamic Column Name changed by the selected Year & Month

[Young_G_Han]

  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.

Factory  |  Operation  | Last Year Total | Last 13 Month by Month | Current Year Total | Current Year Avg.

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

                    Factory  |  Operation  | 2022 Total | 2022 Oct - 2023 Oct by month | 2023 Total | 2023 Avg.

Order

Production

Stock

Priority

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

[Dangar332 · Accepted solution]

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.

[Young_G_Han]

  Dear Dangar332

Nice idea. I supposed that would not be easy.

But your idea is reasonable.

Thank you.