Forum Discussion
Solved
DAX
Just started learning DAX and need help acheiving the following query. I need to match the Tender # from Sheet 1, Column Y with, corresponding Tender # on Sheet 2, Colum X. Then I will have 3 Co...
Hi ren
What I did was to load the data in Power Query, and then merge the data together on the "Tender Number"
What I did then was to create a new calculated column which gave me the Max Value across the 3 values
Max Value = MAX(MAX('Merge1'[Award Value],'Merge1'[Contract Value]),'Merge1'[Extended Total Amount])Which resulted in the final column in the table displaying the data as required.
You can find the link here to the PBIX: https://1drv.ms/u/s!Apxn-69XhcAmiMITsW8F0_YUJPrZgg
