Forum Discussion
Helper IIIDynamic Column Name changed by the selected Year & Month
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?
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 onlyselected 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 imagehere 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.
2 Replies
- Dangar332
Resident Rockstar
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 onlyselected 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 imagehere 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_HanDear Dangar332
Nice idea. I supposed that would not be easy.
But your idea is reasonable.
Thank you.