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...
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!