Forum Discussion
Need help with DAX
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?
3 Replies
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/
Hi,
Share some data and show the expected result.
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,
KellyDid I answer your question? Mark my post as a solution!
