Need help with DAX

[ChayDommeti]

i have 2 tables

Azure Main and under it columns are 

Date

Month

Year

Date and month

Product

cost

another table name is 'Azure Data' and columns are

product ( product list is all filled in rows)

Jan 2020

Feb 2020

and so on

Now i want the cost of each product for each month by taking data from 'azure main' table and populating in the columns of 'azure data'. any help on how i can do that? 

[Anonymous]

Hi @ChayDommeti ，

You should first use transpose to make the Month Year columns of Azure data table as one column,then use "lookupvalue" function to get the cost you need.

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[amitchandak]

@ChayDommeti , do you plan to create a transposed table where months are columns

refer if this can help

https://yodalearning.com/tutorials/power-query-helps-transposing-data/