Forum Discussion

ren's avatar
ren
New Member
8 years ago
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...
  • GilbertQ's avatar
    GilbertQ
    8 years ago

    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 

GilbertQ's avatar
GilbertQ
Super User
8 years ago

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 

ren's avatar
ren
New Member
8 years ago

Thanks Gilbert!

  • GilbertQ's avatar
    GilbertQ
    Super User
    8 years ago
    No worries