define a name for a column then search for a value

[vitorialucena]

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.

[Anonymous · Accepted solution]

Hi @vitorialucena ,

As @wdx223_Daniel  said, you can convert the data into three columns.

(1) In the power query, select the "client" column and right click on "unpivot other columns".

(2)Click "Close and Apply" and then create a table in desktop.

Table 2 = FILTER('Table','Table'[Month]=FORMAT(TODAY(),"mmmm"))

This new table will output the relevant data for the current month.

Best Regards,

Neeko Tang

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

[wdx223_Daniel]

you can transform your table into a three-columns table

client, month, value

then either in dax or in M, it is easy to be referred.

[vitorialucena]

but howw? I'm fairly new to bi