dynamic column names
2 TopicsDynamic measure name
Hello dear members. I need your help. I have created the following measure: Calculate(sum('table'[value]), selectedvalue( 'Version'[version]= 'table'[version])) This measure is dynamin and calculates different scenarios based on user's slicer selection. So if the selection is Actual the measure returns the actual value. If the selection is forecast it returns the forecast value. It works perfectly. I have used that measure and 2 other similar to this in a matrix. The problem is that the column name doesn't change based on the selection but it is stable and based on the measure name. How can I dynamically change the column headers?? Thank you very much1.2KViews0likes6Commentsdefine a name for a column then search for a value
basically, I have a database of values for discount in each month per client: client (txt) january (number) february (number) other months (number) november (number) december (number) name of client 1 5,00 9,00 4,00 2,00 name of client 2 1,00 6,00 5,00 4,00 name of client 3 2,00 0,00 7,00 3,00 so, I have to get the role "today's month" and put it in another table matching (related) the names of the clients. so, as we are in october, I'd get the column named october and put it in anoter table. I don't know if DAX is the best option or it needs to be done in the Power Query, I'm open for possibilites and will be posting it in both topics, if I can.Solved571Views0likes3Comments